Courses
Microsoft Power BI: Data Analysis Professional


- Microsoft Power BI: Data Analysis Professional
Technical
- $1895.00
Course Overview
As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of “big data” is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft Power BI software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables 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, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.
Prerequisites
You should have basic knowledge of Windows including opening applications and opening files from File Explorer. You should have a working knowledge of all topics covered in Excel Novice, Excel Intermediate, and Excel Advanced. Additionally, knowledge of database design concepts and basic programming constructs such as looping and branching, will help you get even more out of this course.
What You Will Learn
- 01Analyzing Data and Reporting with Power BI
- Data Analysis and Visualization for Business Intelligence
- Interact with Reports in Power BI
- 02Connecting to Data
- Create Data Source Connections
- Configure and Manage Relationships
- Save Files in Power BI
- Secure and Troubleshoot Connections
- 03Cleaning, Transforming, and Loading Data
- Load, Clean, and Shape Data with the Query Editor
- Profile Data with the Query Editor
- Shape Data with the Query Editor
- Transform Data with the Query Editor
- 04Visualizing Data with Power BI
- Create Visualizations with Power BI
- Select Visualization Types with Power BI
- 05Enhancing Visuals for Data Analysis
- Customize Visuals and Pages
- Incorporate Tooltips in Visualizations
- 06Modeling Data with Calculations
- Create Calculated Columns with DAX
- Create Calculated Measures and Conditional Columns
- 07Customizing and Filtering Reports
- Create Data Hierarchies
- Filter Reports
- Discover Time-Intelligence Insights
- Configure Slicers for Interactive Filtering
- 08Performing Advanced Analysis
- Create Calculated Tables, Variables, and Parameters
- Perform Statistical Analysis
- Analyze Data with Advanced Power BI Features
- 09Sharing Reports and Creating Dashboards in the Power BI Service
- Publish and Explore Reports in the Power BI Service
- Create Dashboards
- Add Q&A to Dashboards
- 10Managing and Collaborating in the Power BI Service
- Manage Workspaces and Share Content
- Collaborate with the Power BI Service
- 11Enhancing Reports and Dashboards
- Optimize Usability and Performance
- Create Mobile Reports for Power BI
Included With The Course
- Professional textbook (physical and digital)
- Unused copy of any files referenced throughout the textbook.
- Certificate of completion signed by the instructor.
Associated Certifications
Not applicable.
Frequently Asked Questions
We understand that you may have questions, and we’re here to help! Some of the most commonly asked questions about this course are covered below but if they don’t cover what you are looking for feel free to reach out to us through our contact page, and we’ll respond promptly to ensure you get the assistance you require. Your satisfaction is our priority, and we’re committed to making sure you have all the information necessary for a seamless experience.
No. This course is for users of all levels and focuses on what they call social engineering. Social engineering is the use of deception to manipulate individuals into divulging confidential or personal information that may be used for fraudulent purposes. It aims to inform users of technology-related risks and what they can do to protect themselves and their organization from these risks.


