Go back

Power BI Step By Step Connecting To Data Sources Part 2(1st Edition)

Authors:

Grant Gamble

Free power bi step by step connecting to data sources part 2 1st edition grant gamble 1717866239, 978-1717866233
8 ratings
Cover Type:Hardcover
Condition:Used

In Stock

Include with your book

Free shipping: April 04, 2024
Access to 3 Million+ solutions Free
Ask 10 Questions from expert 200,000+ Expert answers
7 days-trial

Total Price:

$0

List Price: $7.99 Savings: $7.99(100%)

Book details

ISBN: 1717866239, 978-1717866233

Book publisher: Independently published (July 22, 2018)

Get your hands on the best-selling book Power BI Step By Step Connecting To Data Sources Part 2 1st Edition for free. Feed your curiosity and let your imagination soar with the best stories coming out to you without hefty price tags. Browse SolutionInn to discover a treasure trove of fiction and non-fiction books where every page leads the reader to an undiscovered world. Start your literary adventure right away and also enjoy free shipping of these complimentary books to your door.

Power BI Step By Step Connecting To Data Sources Part 2 1st Edition Summary: Self-Service Business IntelligencePower BI enables business users to interact with corporate information and to extract the reports and intel they need. Power BI allows users to access reports and dashboards using familiar tools and devices. Self-service BI has never been so user-friendly!The Microsoft Power BI Step-by-Step series will show you how to create compelling visualizations and reports which provide deep insights into your data.This first book in the series is designed to get you up and running with the three main components of Power BI:Power BI Desktopthe Power BI Serviceand Power BI Mobile Apps.What you will Learn from the Power BI Step-by-Step SeriesYou will learn how to connect to a wide variety of data sources, using both Power BI Desktop, and the Power BI Service.You will be able to use the Query Editor to transform and morph data into the right format for your reporting purposes.You will be able to perform complex data modelling operations using relationships, calculated columns, measures, and DAX expressions.You will learn how to share dashboards and reports, with colleagues, business partners and potential clients; and how to use Power BI’s sophisticated security features to control the exact content your audience is able to view.In short, the Power BI Step-by-Step series will equip you with all the skills you need to start using Power BI with confidence.Part 2: Connecting to Data SourcesThe aim of this second book in the series is explore Power BI data connections. However, these tutorials will also provide some further practice on report creation.IntroductionChapter 1: Connecting to Text FilesOverview of the Query EditorClosing and Reopening the Query Settings PaneRenaming a QueryUsing the Query Settings ButtonsApplying Changes Made in the Query EditorEditing an Existing QueryConclusionChapter 2: Connecting to Excel DataWorksheets, Tables and Name RangesImporting Excel Objects into Power BIRecognizing the IconsConclusionChapter 3: Connecting to a Folder of DataBenefits of Connecting to a FolderConnecting to the FolderUpdating the FolderConclusionChapter 4: Connecting to Web DataExamining the Source DataConnecting to the Excel DataConnecting to the Currency Exchange Rate DataQuery Editor: Remove ColumnsQuery Editor: Use First Row as HeadersQuery Editor: Filtering out Unwanted RowsQuery Editor: Renaming a QueryQuery Editor: Creating a Custom ColumnAdding a Report Background ImageAutomatic Detection of RelationshipsUsing the Table VisualCreating Calculated ColumnsUsing the Slicer VisualConclusionChapter 5: Connecting to SQL ServerGetting Set UpComparing the Database to the Data ModelImporting SQL Server ViewsAuthentication ModeEnhancing the Data ModelRefreshing Imported SQL Server DataImport Versus DirectQueryRefreshing DirectQuery SQL Server DataConnecting to Database Tables Using SQL StatementsLeveraging Query FoldingQuery Folding and Native QueriesMonitoring Query FoldingConclusionNext StepsG Com Solutions LimitedG Com Solutions Limited provide Power BI training in Peterborough, London and throughout the UK. Details of their Power BI courses can be found at the following URL:https://gcomsolutions.co.uk/microsoft-power-bi-training-courses/