About this course
Welcome to Cloud Hounds' MS Power College course, Analysing and Visualising Data with Power BI.
Note: To learn the most from this course a desktop PC is recommended.
The truth is all industry sectors can benefit from Power BI. The data analysis principals taught in this course can be applied to all organisations regardless of size. However, the focus for this course, is hospitality.
In these highly competitive times, would an analysis report that can show you:
give you and instant competitive advantage?
Power BI offers powerful analytical tools for all businesses regardless of business size.
Economic uncertainty, rising inflation leading to likely interest rate increases combined with rising job insecurity, stagnate wages and rising inflation will inevitably reduce your consumers, disposable income.
The possible outcomes of the above makes it imperative your product service offering matches consumers expectations.
Add changing consumer demographics to the mix, demand preferences will change. An aging population may lead to a more discerning customer base. Increasing labour costs, recruitment retention problems and higher training costs are likely to impact the ability to maintain product service delivery standards. Particularly as employers become ever more reliant upon zero hour contracts and casual work force.
The profitability of individual companies depends on efficient supply chain management and effective merchandising and marketing.
Negative PR event, data security breach, a decline in year on year (YOY) sales, missed earnings call, market share loss, inventory write-off, forced layoff, business unit closure, technology failure, a lost contract, a change of management, bad data leads to wrong busienss decisions be taken, all possible factors for business demise.
CEO : primarily interested in creating differentiation as well as developing a merchandising strategy.
CFO : primarily interested in optimising inventory, reducing costs and developing a competitive pricing strategy.
Chief Information officer/IT : primarily focused on data security leveraging the Internet to drive increased sales.
Power BI is a cloud-based service. Use your own data, freely available and paid online data all can be utilised and held securely, in one central location, for analysis and accessed, using a range of devices. The principal benefit being decision makers are working with up to date, evidence based information rather than gut instinct and most importantly reports can be distributed and interrogated by the right people at the right time.
Some experience in working with data from Excel, databases, or text files.
This course is available in self-paced format.
Quizzes are an aid to your learning and to help you to fully understand the material. Ideally you should complete the quizzes before you begin the next module.
Learn the key ideas in business intelligence, data analysis, and data visualisation
How to import your data and create automated dashboards from services such as Marketo, Salesforce, and Google Analytics
Learn how to extract, load and transform (ETL) your data.
How to ask and answer business questions using calculations
Presenting your data and publish reports
Automated scheduled report refresh
Producing dashboards and using natural language queries to answer business questions
Sharing dashboards to the right people at the right time
Viewing dashboards using mobile apps
Use your Excel reports within Power BI
Creating bespoke visualisations using your dashboards and reports
Collaborating within groups to develop reports and dashboards
Sharing dashboards according to your needs
Using real time connections to update your data with Power BI
How to connect directly to SQL Azure, and SQL Server Analysis Services
Power BI Development API basics.
Using bespoke graphics in Power BI
Each week, you should spend as much time as you require to understand the principals. Most people generally spend 2-4 hours on the course, completing the following:
This course includes coursework and is not, graded. Each module in the course includes several videos, and short quizzes, and lab exercises.
If you are fortunate to be studying within a group you should encourage each other to ask questions. Doing so helps to consolidate learning and understanding. If you have issues you may find asking your fellow students for help might prove mutually beneficial. You never know they may have already found a solution!
If you have questions visit Cloud Hound PRIVATE Flaurum forum. The forum is open to all students and staff, and while we love to see passionate engagement, abusive or inflammatory behaviour will not be tolerated. If you wish to join the group email to firstname.lastname@example.org and your application to join will be considered. Alternatively you can click the Facebook Power BI Group image button below and register your interest to join.
Due to the volume of students studying this course, it will not be possible to answer every question individually. You should still post questions however, because in many cases, your fellow students may be able to help.
Completing the survey will help with development of further courses.
Obviously you do other wise you wouldn't be viewing this course.
High level overview of Power BI process.
Helicopter overview of connecting to data services for example Adobe, Google Analytics, Acumatica, MailChimp, SQL to Power BI interrogating the data and publish reports & dashboards.
Power BI Desktop can connect to all sorts of data sources and then help you, to extract, load and transform the data into a format you can start to build relationships in turn enable you to analysis and visualise the data.
This video demonstrates how to use Power BI Desktop to connect to a database
In today’s world sustained competitive advantage at its core necessitates data transformation. Master this essential skill and you will remain one step ahead of your competitors.
Assume for a moment. You have a number of businesses operating in different geographic locations. Each month or week they submit sales reports to your offices. The data needs to be added to your database. This video illustrates how to append such files to your data set.
In this presentation, the focus is upon a more complex real-world example, for example, exporting a matrix-like data format and transforming the data layout into a column format a style that works well for Power BI.
Create tables within Power BI. Manually type entries or copy and paste data then transform and query data to generate spectacular eye-catching reports.
The workshop is an important opportunity for you to confirm what you do or don’t understand. Mistakes are often a better learning experience than getting everything right the first time so if you do make mistakes no one needs to know. On the positive side, you are unlikely to repeat your error. Good luck.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.