Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

5 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your subject-matter expertise

This course is part of the Mastering Power BI for Data Analytics & Storytelling Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 2 modules in this course

This course is designed for professionals who want to practice projects that follow industry standards. The course consists of two projects, one of which deals with designing databases in Snowflake and connecting them with Power BI for analysis, and the other focuses on managing inventory and forecasting trends, which assist in decision-making.

By the end of this course, you will be able to: 1. Explain Snowflake cloud Data Platform 2. Demonstrate the use of the Snowflake platform to store and manage data 3. Apply Power BI Service features to elevate the quality of your Reports and implement Dashboards 4. Create Paginated Reports and Dashboards on Power BI Service, utilizing its prevalent features This long course is designed for Data Analyst, Data Administrator, and Business Analyst seeking to enhance their analytical and design skills. Prior experience with MS Excel and SQL is beneficial but not mandatory for this course. Join us on this journey to enhance your decision making skills and elevate your analytical and design capabilities.

Welcome to Power BI Capstone Projects. In this module, we will understand the capabilities of Snowflake and Power BI analytics features. The two projects are designed to assimilate learners and give more detailed information on the features that make Power BI a powerful tool in data analysis. The first project is designed to manipulate data in Snowflake and integrating it with Power BI. The second project analyzes the store data to increase it's profitability.

What's included

29 videos10 readings4 assignments2 discussion prompts

29 videosTotal 125 minutes

Course Introduction2 minutesPreview module
Introduction to Snowflake Cloud Data Platform5 minutes
Understand Data warehouse and Schema5 minutes
Building Tables3 minutes
Manipulating Data5 minutes
Structuring Data4 minutes
Stored Procedures and Views6 minutes
Downloading Data5 minutes
Time Travelling3 minutes
Importing data from Snowflake5 minutes
Integrating Snowflake with Power BI5 minutes
Creating First Report4 minutes
Optimizing Visuals in First Report3 minutes
Creating Second Report4 minutes
Optimizing Visuals in Second Report4 minutes
Publishing Reports5 minutes
Formatting Dashboards on Service2 minutes
Analyzing the Problem4 minutes
Modeling Data4 minutes
Report Creation2 minutes
Visualizing Data3 minutes
Optimizing Visuals for the Report4 minutes
Formatting the Report1 minute
Finishing the Design of Report 15 minutes
QnA Report3 minutes
Row Level Security4 minutes
Managing Roles and Privileges6 minutes
Publishing Dashboards3 minutes
Utilizing Power BI Service Features2 minutes

10 readingsTotal 230 minutes

Welcome to Power BI Capstone Project10 minutes
Project Description20 minutes
Requirements for Installing Power BI Desktop10 minutes
Power BI Licenses10 minutes
Connect to Snowflake10 minutes
Load Data into Snowflake30 minutes
Unload Data from Snowflake45 minutes
Project Description20 minutes
Power BI Security45 minutes
Query Diagnostics in Power BI30 minutes

4 assignmentsTotal 14 minutes

Knowledge Check: Integrating Power BI with Snowflake5 minutes
Knowledge Check: Store Data Analysis5 minutes
Practice Quiz: Insights on Snowflake2 minutes
Practice Quiz: Data analysis in Power BI2 minutes

2 discussion promptsTotal 20 minutes

Introduce Yourself10 minutes
Have you used any other platform or software apart from Snowflake to run SQL queries10 minutes

This module is designed to assess an individual on the various concepts and teachings covered in this course. Answer a comprehensive quiz which marks you as a learner who is confident in working with Power BI.