Computers

Microsoft Business Intelligence Tools for Excel Analysts

Author: Michael Alexander,Jared Decker,Bernard Wehbe

Publisher: John Wiley & Sons

ISBN: 1118821521

Category: Computers

Page: 384

View: 5213

Introduces business analysts to the toolset and reporting capabilities that can be used to source and incorporate large datasets in analytics, including PowerPivot, SQL Server, and SharePoint, covering such topics as how to move data between these tools,how to leverage relational databases, and creating visualizations and dashboards.
Computers

Datenanalyse mit Microsoft Power BI und Power Pivot für Excel

Author: Alberto Ferrari,Marco Russo

Publisher: dpunkt.verlag

ISBN: 3960882513

Category: Computers

Page: 264

View: 8836

Um die richtigen Erkenntnisse aus Ihren Daten ziehen zu können, müssen Sie sie richtig modellieren. Microsoft bietet Ihnen starke und zugleich zugängliche Tools für die Datenmodellierung, von Power BI bis Power Pivot für Excel. Wie Sie diese Tools effektiv einsetzen, zeigen Ihnen Alberto Ferrari und Marco Russo, international anerkannte Experten für Datenanalyse mit Microsoft, in diesem Buch. Nach einer kurzen Einführung in das Konzept der Datenmodellierung lernen Sie Schritt für Schritt anhand realer Beispiele mit steigendem Schwierigkeitsgrad, wie Sie einfache Tabellen in umfassende und aussagekräftige Modelle verwandeln. Aus dem Inhalt: Einführung in die DatenmodellierungHeader/Detail-TabellenDenormalisierte Faktentabellen und dimensionsübergreifende FilterungDatumsdimensionen erstellenHistorische Attribute: langsam und schnell veränderliche DimensionenSnapshots aggregierenDatums- und Zeitintervallem:n-BeziehungenUnterschiedliche GranularitätenSegmentierungsmodelleWährungsumrechnung Unter dem Label "Microsoft" erscheinen exklusiv im dpunkt.verlag Übersetzungen der besten Microsoft Press-Titel.

Excel-VBA für Dummies

Author: John Walkenbach

Publisher: John Wiley & Sons

ISBN: 3527709282

Category:

Page: 411

View: 7077

Um noch mehr aus Excel herauszuholen, empfiehlt sich die VBA-Programmierung, mit der Sie Excel auf Ihre Bedürfnisse zuschneiden können. John Walkenbach zeigt Ihnen, wie Sie Excel-Berechnungen mit VBA automatisieren. Er erklärt Ihnen zunächst die notwendigen VBA-Grundlagen und wichtigsten Werkzeuge sowie VBA-Abläufe des VBA-Editors. Außerdem erhalten Sie eine Übersicht über die wichtigsten Bestandteile und Begriffe, die für die VBA-Programmierung in Excel relevant sind, und Sie erfahren, wie Sie Programmierfehler ausfindig machen und beheben.
Computers

Microsoft Business Intelligence For Dummies

Author: Ken Withee

Publisher: John Wiley & Sons

ISBN: 9780470606346

Category: Computers

Page: 432

View: 9245

Learn to create an effective business strategy using Microsoft's BI stack Microsoft Business Intelligence tools are among the most widely used applications for gathering, providing access to, and analyzing data to enable the enterprise to make sound business decisions. The tools include SharePoint Server, the Office Suite, PerformancePoint Server, and SQL Server, among others. With so much jargon and so many technologies involved, Microsoft Business Intelligence For Dummies provides a much-needed step-by-step explanation of what's involved and how to use this powerful package to improve your business. Microsoft Business Intelligence encompasses a broad collection of tools designed to help business owners and managers direct the enterprise effectively This guide provides an overview of SharePoint, PerformancePoint, the SQL Server suite, Microsoft Office, and the BI development technologies Explains how the various technologies work together to solve functional problems Translates the buzzwords and shows you how to create your business strategy Examines related technologies including data warehousing, data marts, Online Analytical Processing (OLAP), data mining, reporting, dashboards, and Key Performance Indicators (KPIs) Simplifies this complex package to get you up and running quickly Microsoft Business Intelligence For Dummies demystifies these essential tools for enterprise managers, business analysts, and others who need to get up to speed.
Computers

PowerPivot for Business Intelligence Using Excel and SharePoint

Author: Barry Ralston

Publisher: Apress

ISBN: 143023380X

Category: Computers

Page: 304

View: 3259

PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files. PowerPivot for Business Intelligence Using Excel and SharePoint is your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that you’ll encounter when using PowerPivot. Each chapter takes you through a solution technique that’s been proven in the real world. Covers the leading technology for bringing data analytics to the desktop Presents real-world solutions to real-world scenarios Written by a Microsoft Virtual Technical Specialist (VTS) for business intelligence What you’ll learn Install and verify the PowerPivot software Integrated existing, available data to deliver business intelligence Leverage Time Intelligence to report change over time Write Data Analysis Expressions (DAX) to create custom measures Identify and implement solutions for role-playing dimensions Recognize and work-around PowerPivot’s missing features Who this book is for PowerPivot Solutions for Excel and SharePoint is aimed at information workers and data analysts who typically use Excel to drive business decisions. The book shows how you can apply PowerPivot to problems typically addressed through complicated and arcane spreadsheet techniques. Business people without the time and interest in learning Excel arcane will especially appreciate how PowerPivot enables them to easily create models and perform analysis far in advance of anything they could do using Excel alone. Table of Contents Getting Started with PowerPivot for Excel Hello World, PowerPivot Style Combining Data Sources Data Analysis Expressions A Method to the Madness Installing PowerPivot for SharePoint Collaboration, Version Control, and Management PowerPivot As a Data Source PowerPivot and SQL Server Reporting Services PowerPivot and Predictive Analytics Tips, Tricks, and Traps
Computers

Knight's Microsoft Business Intelligence 24-Hour Trainer

Author: Brian Knight,Devin Knight,Adam Jorgensen,Patrick LeBlanc,Mike Davis

Publisher: John Wiley & Sons

ISBN: 0470889632

Category: Computers

Page: 408

View: 1348

This book and video package introduces IT professionals, DBAs, and business analysts who are just starting to get a handle on Microsoft Business Intelligence tools, (It is therefore intended to be the first book to read---and the first video to watch--before moving on to Wrox books that focus on each of the individual Microsoft BI components.) The book and accompanying video give the novice reader just enough experience with the product to perform basic business analysis and reporting. The book covers all components and related tools that comprise the Microsoft BI toolset. These include SQL Server Integration, Reporting, and Analysis Services, data mining, plus the new BI features of Office 2010. Background theory is given as needed to provide context for those readers with no prior BI knowledge or experience. The book starts with a basic primer on business intelligence and data modeling. The following sections provide step-by-step lessons that show readers how to use: SQL Server Integration Services SQL Server Analysis Services SQL Server Reporting Services Excel BI, including PowerPivot SharePoint The book tightly integrates instructional videos--provided on the book's accompanying DVD--with each of the hands-on lessons found in the book. Each lesson comprises three major components: An Introduction that describes how a certain component or process works. A "Try It Out" section that gives readers the chance to practice what they've learned A Video showing how the author works through each lesson
Computers

Beginning Power BI with Excel 2013

Self-Service Business Intelligence Using Power Pivot, Power View, Power Query, and Power Map

Author: Dan Clark

Publisher: Apress

ISBN: 1430264462

Category: Computers

Page: 324

View: 4890

Understanding your company’s data has never been easier than with Microsoft’s new Power BI package for Excel 2013. Consisting of four powerful tools—Power Pivot, Power View, Power Query and Power Maps—Power BI makes self-service business intelligence a reality for a wide range of users, bridging the traditional gap between Excel users, business analysts and IT experts and making it easier for everyone to work together to build the data models that can give you game-changing insights into your business. Beginning Power BI with Excel 2013 guides you step by step through the process of analyzing and visualizing your data. Daniel R. Clark, an expert in BI training and a regular speaker on these topics, takes you through each tool in turn, using hands-on activities to consolidate what you’ve learned in each chapter. Starting with Power Pivot, you will create robust scalable data models which will serve as the foundation of your data analysis. Once you have mastered creating suitable data models, you will use them to build compelling interactive visualizations in Power View. It’s often necessary to combine data from disparate sources into a data model. Power Query allows you to easily discover, combine, and refine data from a variety of sources, so you can make accurate judgments with all the available information. Geographical awareness is another common requirement of data analysis. Using Power Maps you will create captivating visualizations that map your data in space and time. Beginning Power BI with Excel 2013 is your practical guide to getting maximum insight from your data, and presenting it with impact.
Computers

Business Intelligence in Microsoft SharePoint 2013

Author: Norm Warren,Mariano Neto,Stacia Misner,Ivan Sanders,Scott A. Helmers

Publisher: Pearson Education

ISBN: 0735675872

Category: Computers

Page: 406

View: 8125

Dive into the business intelligence features in SharePoint 2013—and use the right combination of tools to deliver compelling solutions. Take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server 2012. Led by a group of BI and SharePoint experts, you’ll get step-by-step instructions for understanding how to use these technologies best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst. Discover how to: Manage the entire BI lifecycle, from determining key performance indicators to building dashboards Use web-based Microsoft Excel services and publish workbooks on a SharePoint Server Mash up data from multiple sources and create Data Analysis Expressions (DAX) using PowerPivot Create data-driven diagrams that provide interactive processes and context with Microsoft Visio Services Use dashboards, scorecards, reports, and key performance indicators to monitor and analyze your business Use SharePoint to view BI reports side by side, no matter which tools were used to produced them
Computers

Excel Formeln und Funktionen für Dummies

Author: Ken Bluttman

Publisher: John Wiley & Sons

ISBN: 3527802533

Category: Computers

Page: 399

View: 5308

In Excel 2016 gibt es mehr als 400 Funktionen, von ABRUNDEN bis ZZR. Aber welche der vielen Funktionen erleichtert Ihnen Ihre Arbeit? Wie setzen Sie die Funktionen richtig ein? Wie lautet die Syntax? Dieses Buch stellt Excel-Einsteigern die 150 nï¿1⁄2tzlichsten Excel-Funktionen ausfï¿1⁄2hrlich vor. Der richtige Gebrauch wird anhand von Alltagsbeispielen deutlich. Hier sind nur drei: Lï¿1⁄2schen Sie ï¿1⁄2berflï¿1⁄2ssige und unschï¿1⁄2ne Leerzeichen in Ihren Tabellen, analysieren Sie die Leistungsverteilung in einer Schulklasse (oder einem Verkaufsteam), vergleichen Sie Kredite mit unterschiedlichen Laufzeiten und ermitteln Sie mit ZZR die Anzahl der Zahlungsperioden bei einer vorgegebenen Rï¿1⁄2ckzahlungsrate.
Computers

Foundations of SQL Server 2008 R2 Business Intelligence

Author: Guy Fouche,Lynn Langit

Publisher: Apress

ISBN: 1430233249

Category: Computers

Page: 448

View: 2464

Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire exciting gamut of business intelligence tools included with SQL Server 2008. Microsoft has designed SQL Server 2008 to be more than just a database. It’s a complete business intelligence (BI) platform. The database is at its core, and surrounding the core are tools for data mining, modeling, reporting, analyzing, charting, and integration with other enterprise-level software packages. SQL Server 2008 puts an incredible amount of BI functionality at your disposal. But how do you take advantage of it? That’s what this book is all about. Authors Guy Fouché and Lynn Langit show how to implement end-to-end BI solutions using SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and other tools in the Microsoft business intelligence toolkit. You’ll learn about all-features such as PowerPivot and Report Builder 3.0. Also provided are clear examples of predictive analysis made possible through powerful data mining features in SQL Server. If you’re an analyst or developer working with SQL Server 2008 who is charged with delivering results that drive business success, you can’t afford to be without this book; you can’t afford to ignore the powerful business intelligence suite that Microsoft has placed at your disposal. Provides the “big picture” of Microsoft’s BI tool suite Covers PowerPivot and other game-changing technologies introduced alongside SQL Server 2008 Release 2 Gives a practical analysis of features based on real-world practices What you’ll learn Apply dimensional- and fact-based modeling to create OLAP schemas Optimize data extraction and transformation with SQL Server Integration Services Develop OLAP and data-mining solutions using SQL Server Analysis Services Create compelling reports using the new Report Builder 3.0 in SQL Server Reporting Services Deliver self-service business-intelligence via Microsoft PowerPivot Manage and maintain control over your business intelligence environment Who this book is for Foundations of SQL Server 2008 R2 Business Intelligence is for business intelligence analysts and developers wanting to employ the full stack of business intelligence tools that are part of SQL Server. The book also appeals to database administrators managing databases in support of business intelligence efforts. Table of Contents What Is Business Intelligence? OLAP Modeling Concepts Introducing OLAP Modeling with SSAS Intermediate OLAP Modeling with SSAS Advanced OLAP Modeling with SSAS Cube Storage and Aggregation Introducing SSIS Intermediate SSIS Advanced SSIS Reporting Tools Data Mining with Excel Introducing PowerPivot Introduction to MDX Introduction to Data Mining
Computers

Excel 2002 für Dummies

Author: Greg Harvey

Publisher: Wiley-VCH

ISBN: 9783527700523

Category: Computers

Page: 352

View: 946

Sie haben keine blasse Ahnung von Tabellenkalkulationen, möchten aber Ihre Zahlen endlich in den Griff bekommen? Oder zählen Sie zu diesen Excel-begeisterten Buchhaltern, die mit Spannung auf die neuen Features der 2002er Version warten, um Ihren Chef mal wieder zu beeindrucken? In diesem Buch führt Sie Greg Harvey Schritt für Schritt in die Welt der Tabellen-kalkulation ein und demonstriert Ihnen das grandiose Organisationstalent von Excel 2002: unterschiedliche Datentypen zusammenstellen, Berechnungen durchführen, anschauliche Diagramme fabrizieren. Sie erfahren: * Wo der Unterschied zwischen Arbeitsmappen und Arbeitsblättern liegt * Wie Sie Ihre eigenen Tabellenblätter erstellen, bearbeiten, formatieren und drucken * Wie Sie aus Excel direkt Tabellen, Arbeitsblätter und Mappen per E-Mail versenden können * Wie Sie Ihre Excel-Tabelle auf der Website Ihres Unternehmens veröffentlichen * Welche neuen Features Excel 2002 zu bieten hat: ClipArts in Ihr Tabellenblatt einfügen, Webseiten in Excel bearbeiten u.v.a.m. * Wie Sie Daten und Texte aus allen Office XP-Programmen in Ihr Excel-Sheet integrieren
Computers

Excel 2007 VBA-Programmierung für Dummies

Author: John Walkenbach

Publisher: Wiley-VCH

ISBN: 9783527704118

Category: Computers

Page: 385

View: 9495

Um noch mehr aus Excel herauszuholen, empfiehlt sich die VBA-Programmierung, mit der Sie Excel auf Ihre Bedürfnisse zuschneiden können. John Walkenbach zeigt Ihnen in "Excel 2007 VBA-Programmierung für Dummies", wie Sie Excel-Berechnungen mit VBA automatisieren. Er erklärt Ihnen zunächst die notwendigen VBA-Grundlagen und wichtigsten Werkzeuge sowie VBA-Abläufe des VBA-Editors. Außerdem erhalten Sie eine Übersicht über die wichtigsten Bestandteile und Begriffe, die für die VBA-Programmierung in Excel relevant sind, und Sie erfahren, wie Sie Programmierfehler ausfindig machen und beheben.
Computers

Excel 2016 für Dummies

Author: Greg Harvey

Publisher: John Wiley & Sons

ISBN: 3527802304

Category: Computers

Page: 389

View: 1329

Man denkt zuerst an Excel, wenn man an Tabellen denkt, zumindest wenn man sie auf dem Computer erstellt. Greg Harvey stellt Ihnen in diesem Buch die neue Version des Tabellenkalkulationsprogramms vor. Er f?hrt Sie Schritt f?r Schritt in die Welt der Tabellen, Diagramme, Formeln und Funktionen ein und gibt Ihnen zahlreiche Tipps und Tricks an die Hand, wie Sie Ihre Arbeit mit Excel so effizient wie m?glich gestalten k?nnen. Dank dieser gelungenen Anleitung kommen Excel-Neulinge und Umsteiger auf die Version 2016 schnell und sicher mit dem Programm zurecht.
Computers

Building Dashboards with Microsoft Dynamics GP 2016

Author: Belinda Allen,Mark Polino

Publisher: Packt Publishing Ltd

ISBN: 1786464047

Category: Computers

Page: 354

View: 4009

Learn to build professional and powerful dashboards with Microsoft Dynamics GP and Excel About This Book This book provides a core foundation for you to understand the ever-changing Microsoft Power BI Through this book, you'll understand how data flows and is secured between Microsoft Dynamics GP and Microsoft Excel You'll see how to create amazing dashboards using various tools such as Excel 2016, Power BI, Jet Express, and more Who This Book Is For This book is geared up for analysts and accountants keen on building and maintaining professional dashboards with Microsoft Excel 2016 for Microsoft Dynamics GP 2016 data, and building financials with visuals using the New Jet Reports Express Tool for Dynamics GP. An introduction is provided for those who want to maintain dashboards in Microsoft Power BI. What You Will Learn Use GP Data in Excel 2016 in a meaningful way Build basic financial statements using Jet Reporting Express, including visualizations Understand the foundation of Power BI and its components Get and maintain data from Dynamics GP in Power BI Find out how to use the Power BI Query Editor (the Get and Transform feature in Excel 2016) Format basic visualizations to get better insights Understand Jet Reports Express, which is used to create basic financial statements Use the new Dynamics GP features, such as OData and adding Power BI tiles on the home page In Detail Microsoft Dynamics GP is a complete ERP solution that is extremely beneficial for small to midsize organizations in helping them grow exponentially. The book shows you in detail how to build great-looking dashboards with Microsoft Dynamics GP that enhance a company's decision-making processes. This guide will take you from the basics of setting up and deploying to creating secure, refreshable Excel reports. Using a whole host of tools available within Microsoft Dynamics GP and Excel, this tutorial will show you how to visualize your data using simple conditional formatting techniques and easy-to-read charts, and allow you to make your data interactive with slicers. We will also cover core topics such as Business Analyzer, Microsoft SQL Reporting services reports, BI360, and more. You will find out to use Power BI, share and refresh data and dashboards in Power BI, and use Power BI Query Editor. By the end of this book, you will have all the information required to build interactive dashboards using Dynamics GP. Style and approach The book takes a step-by-step approach and contains real-world examples that provide the building blocks to create engaging dashboards. This practical guide is all about doing. Get your data, open up Excel, and go!
Computers

Projektmanagement mit Excel

Projekte planen, überwachen und steuern. Für Excel 2010, 2013 und 2016

Author: Ignatz Schels,Uwe M. Seidel

Publisher: Carl Hanser Verlag GmbH Co KG

ISBN: 3446448500

Category: Computers

Page: 348

View: 4481

Professionelle und erfolgreiche Projektarbeit ist keine Hexerei! Allerdings scheitern viele Projekte am Einsatz der richtigen Software, denn teure Projektverfolgungs-Software ist nicht immer vonnöten. Hier zeigen die Autoren, wie man diese Aufgabe mit Excel löst. Ein Projekt komplett geplant, budgetiert und gesteuert - Am Beispiel eines inzwischen real existierenden Golfplatzes zeigen die Autoren praxisnah, wie ein Projekt komplett geplant, budgetiert und gesteuert wird. - Dabei kommt keine teure Projektverwaltungssoftware zum Einsatz. Die Autoren zeigen, wie diese Arbeit mit Hilfe von Excel und VBA automatisiert werden kann. Sie verknüpfen Excel intelligent mit Outlook und anderen Programmen. Mit diesem Buch verlieren Terminpläne, Budgetüberwachung und Projekt-Reporting ihren Schrecken. Es eignet sich für die Excel-Versionen 2010, 2013 und 2016.