Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more.
Power Query brings the power of Data to the ordinary business and the Excel user.
Power View is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers
Power Query is an Excel add-in, available in Excel 2010 Professional Plus and Excel 2013. In Excel 2016 it is known as Get and discover data. Power Query can be described as SQL for Excel users (without the need for knowing SQL). It allows uses find data from multiple sources, combine data, transform data, and make the data usable for reporting and data analytics.
LEARN HOW SET UP QUERIES TO EXTRACT DATA FROM MULTIPLE SOURCES, TRANSFORM DATA OF DIFFERENT TYPES AND LEARN HOW TO USE POWER QUERY TO AUTOMATE DAILY TASKS.
MICROSOFT'S EXCEL, WHICH INCLUDES POWER QUERY, IS NOW PART OF A BI SYSTEM. IF YOU WANT TO IMPROVE YOUR EXCEL SKILLS FAR BEYOND THE BASIC LEVEL AND BRING BUSINESS ANALYTICS AND DATA TO YOUR ORGANISATION THEN THIS COURSE IS FOR YOU
Power View is available in Excel 2013 and SharePoint Server 2010. In Power View, you can quickly create a variety of visualizations, from tables and matrices to bubble charts and sets of small multiple charts. For every visualization you want to create, you start with a table, which you can then easily convert to other visualizations, to determine which one best illustrates your data.
LEARN TO USE POWER VIEW CHARTS AND MAPS OF ALL TYPES TO VISUALIZE DATA TO AID BUSINESS DECISIONS AND SET UP HIERARCHY TO MAKE VISUALIZATIONS MORE INTERACTIVE
MICROSOFT'S EXCEL, WHICH INCLUDES POWER VIEW, IS NOW PART OF A SELF SERVICE BI SYSTEM. IF YOU WANT TO IMPROVE YOUR EXCEL SKILLS FAR BEYOND THE BASIC LEVEL THEN THIS COURSE IS FOR YOU
In section one of this course we will start at the very basics and learn how to set up Power Query. In this section you will find sample data to download, so you can practice along. You will then work though a case study on how an organisation can use internal data of different file types, such as Text files and Excel files, and then combine this data with External data from the web to accurately calculate the potential market size, the actual market size and the portion of the market held by the company. This case study will give you a solid working knowledge of Power Query.
Next we will look at some more advanced features of Power Query. You will be introduced to the language use, which is known as M, you will learn how to query not just files of different types but also Folders of data. You will also learn how to sort “Bad Data” and user Power Query to automate reoccurring tasks.
You will also lean learn how, and when to visualize data using
• Column and Bar Charts
• Pie Charts
• Line charts
• Scatter/bubble charts
You will learn how to set up hierarchy and make these charts more interactive to give deeper analysis and how to visualize data on Maps
In addition to this through the sample data, will look at how trends in data are easily spotted using visualization, making business decisions easier and actionable.
In this lesson you will learn how to download and install Power Query for Excel
Where to go to download Power Query For Excel and what is supported
Download the following zip file so you can work along in Power Query
Introduction to the case study that we will be working in this this Power Query section of this course Power Query and Power View - Excels Power Tools
Learn how to connect Power Query to an excel file and transform the data
Carry out the following activity to ensure you can connect to an excel file using Excels add in Power Query
Learn how to connect Power Query to a Text file and transform the data
Carry out the following activity so you know you can connect Power Query to a .txt file
Learn how to get and transform web data using Excels Power Query add in
In this activity you will practice connecting to Web data and transforming that data using Excels Power Query
In this lesson you will learn how to merge and analyse the data
Carry out the following activity to merge and analyse data
When you connect to a folder of data using power query in Excel, once you add a new file or update a file in the folder, your data will also update. In this lesson you will learn how to connect to a folder of Excel files in Power Query ( Get and Transform Data) and you will also be introduced to Power Query language known as M
Learn how to connect to a folder of data using Excels Power Query and how to update the folder and query together
Not all data that you connect to will be in a format that you can use, this type of data is know as bad data. In this lesson you will learn how to can connect to and transform bad data into a usable format
Carry out the following activity in Power Query to learn how to connect to and transform bad data
Sometimes data is in a form know as pivoted data, which is difficult to analyse. Learn how to use power query to unpivot data
Carry out the following Activity
Here are some useful resources for Excels Add in Power Tool, Power Query
Before we move into Excels Power View, lets get a quick overview of this section
In this lesson we will look at turning on Power View in Excel 2013 and we will also look at the Power View Ribbons
In this lesson we will look at the data set that we will use for this course. It is a good idea to familiarize your self with the data set so that you have an idea of values and fields that you can plot and visualize
Learn how to work with Column charts and interactive column charts in Power View by adding ad hoc hierarchy
Carry out this activity in Excels Power View
learn how to work with Pie Charts and add hierarchy to the data model
Learn to use Pie charts and add hierarchy in Power View
Learn how to create Line charts and use line charts in Power View to spot trends in your data
Carry out the following activity to analyse data and find trends using Line charts in Excels Power View
Learn how to visualize data on a map and how to make sure you get the correct map locations
Carry out the following Activity to create a Map Visualization using Power View in Excel to analyse data
Learn how to visualize data using an animated Scatter chart
Carry out the following activity to create a Moving Scatter Charts in Excels Power View to analyse data
In this lesson you will learn how to use cards for visualization and tiles to filter the visualizations
In this lesson you will learn how to add images to the data source for use in Cards and Tiles and how to update the data connection
Carry out the following activity for adding image in Excels Power View
In this lesson you will learn how to work with tables of data in Excel with out the need for knowing Powerpivot
Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accountant, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.
Now an E-learning Educator 5+ years, Paula also has a focus on E-learning and online teaching. Drawn from her online teaching experience,Paula has a number of courses available to online teachers to help bridge the skills gap for those that teach or wish to teach online.