Data Analyst Professional
with Power BI
12 - 13 July 2023
HASI Offerings
A Data Analyst Professional with Power BI is a person who has developed proficiency in utilizing Microsoft Power BI to analyse, model, and visualize data. Microsoft Power BI is a business analytics service that provides interactive visualizations and business intelligence capabilities with an interface simple enough for end-users to create their reports and dashboards. As a Data Analyst Professional with Power BI, one can connect to various data sources, transform, and clean data, create interactive data visualizations, and share insights with stakeholders. A proficient Power BI user is skilled in data modelling, DAX (Data Analysis Expressions) language, and best practices for creating effective data visualizations. By leveraging Power BI’s features such as Power Query, Power Pivot, and Power BI Services, a Data Analyst Professional with Power BI can handle complex data sets and generate insights that drive informed decision-making.
What you will learn?
At the end of a course on becoming a Data Analyst Professional with Microsoft Power
BI, the following are some of the key takeaways that participants may have:
- Proficiency in using Microsoft Power BI for data analysis, modelling, and visualization tasks.
- Knowledge of data modelling techniques and best practices.
- Understanding of the DAX language for creating custom calculations and measures.
- Ability to connect to various data sources, transform and clean data, and create interactive data visualizations.
- Familiarity with advanced features such as Power Query, Power Pivot, and Power BI Services.
- Ability to create effective dashboards and reports for sharing insights with stakeholders.
- Knowledge of best practices for data visualization and effective communication of insights.
- Understanding of data security and governance principles in the context of Power BI.
- Exposure to real-world data analysis and visualization scenarios to apply the knowledge gained during the course.
- Confidence to pursue a career as a Data Analyst Professional with Microsoft Power BI.
Who should attend?
The Data Analyst Professional with Microsoft Power BI course is ideal for individuals
who want to develop skills in data analysis, modelling, and visualization using the
Power BI platform. The course is suitable:
- Business intelligence professionals who want to expand their skill set and learn new tools for data analysis and visualization.
- Data professionals who want to learn Power BI as a tool for data analysis and visualization.
- Business professionals who need to work with data to make informed decisions and communicate in-
sights to stakeholders. - Anyone interested in learning data analytics and visualization skills with a focus on the Power BI platform.
What is the content of 2-Day Training?
Day 1
Session 1: Introduction to Power BI
- Overview of Power BI
- Installation and configuration
- Creating a Power BI account
- Power BI user interface
Session 2: Data Sources in Power BI
- Overview of data sources
- Importing data from Excel
- Connecting to databases
- Importing data from web sources
Session 3: Data Modelling in Power BI
- Introduction to data modelling
- Creating a data model in Power BI
- Using relationships in data modeling
- Creating calculated columns and measures
- Using DAX formulas
Day 2
Session 4: Power BI Visualizations
- Introduction to Power BI visualizations
- Creating basic visualizations
- Using custom visuals
- Formatting and customization of visualizations
Session 5: Dashboards and Reports in Power BI
- Introduction to dashboards and reports
- Creating a dashboard in Power BI
- Creating a report in Power BI
- Sharing and collaborating on dashboards and reports
Session 6: Advanced Power BI Techniques
- Advanced data modeling techniques
- Advanced DAX formulas
- Power Query transformations
Budget
The cost will be submitted through quotation
About the Trainer
Dr. Aidarus Mohamed Ibrahim
The trainer is an experienced professional with over 10 years of experience in data analysis, financial data analysis, and teaching. He has
previously worked as a data analysis consultant at the International Law Development Law Organization (IDLO) and as a lecturer at Universiti Teknologi Petronas. His extensive experience in data analysis and financial data analysis has given him a deep understanding
of the industry and the tools and techniques required to derive insights from complex data sets. Currently, he works as a consultant and Adjunct Professor, sharing his knowledge and
expertise with others. As a trainer, he is able to deliver effective training programs that help participants develop the skills and knowledge required to become successful Data Analyst Professionals with Microsoft Power BI. trainer with 10 years practical experiences.
How do I register?
- Call 063 4222191 || 065 7555549 to register
- You can register online through www.hasiconsulting.com
- You can also register by coming to HASI Consulting Office at1st Street, Burj Omaar Building, 3nd Floor, Room 301 & 302, Hargeisa., Hargeisa, Somalia