Course length: 3-days
About this Course
Students will gain a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service and the Power BI Mobile App. Today at an increasing pace, technology is interwoven with our business and lives with more data collected about business activities. Learn to apply the application to “big data.” The explosion of could computing provides an abundance of computational power and storage, allowing organizations to capture and store data, leveraging that data effectively and providing timely insights and a competitive advantage.
The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze and report insights and trends from data. Microsoft Power BI is designed for this purpose. Power BI was built to connect to a wide range of data sources, and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI’s data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, dashboards, and stories that bring data to life and turn data into thoughtful action.
At Course Completion
After completing this course, students will be able to:
Perform Power BI desktop data transformation.
Describe Power BI desktop modelling.
Create a Power BI desktop visualization.
Implement the Power BI service.
Describe how to connect to Excel data.
Describe how to collaborate with Power BI data.
Connect directly to data stores.
Describe the Power BI developer API.
Describe the Power BI mobile app.
Excellent knowledge of relational databases and reporting.
Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
Some exposure to basic programming constructs (such as looping and branching).
An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Familiarity with Microsoft Office applications – particularly Excel.
Module 1: Introduction to Self-Service.
Module 2: Introducing Power BI.
Module 3: Power BI.
Module 4: Shaping and Combining Data
Module 5: Modeling data.
Module 6: Interactive Data Visualizations. T
Module 7: Direct Connectivity.
Module 8: The Developer API.
Module 9: Power BI mobile app.
This class prepares you for Exam 70-778 Analyzing and Visualizing Data with Power BI.
To earn the MCSA BI Reporting you must also take Exam 70-779 Analyzing Data with Excel
Microsoft has announced this exam is scheduled to retire on January 31, 2021. It will remain on your transcript and as new classes are introduced it may possibly be used as prerequisites.