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: 9866

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.

Oracle Database 11g - DBA-Handbuch

Eine skalierbare und sichere Oracle Enterprise Datenbank administrieren

Author: Bob Bryla,Kevin Loney

Publisher: N.A

ISBN: 9783446413795

Category:

Page: 717

View: 9672

Excel-VBA für Dummies

Author: John Walkenbach

Publisher: John Wiley & Sons

ISBN: 3527709282

Category:

Page: 411

View: 8501

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

M

Daten abfragen und verarbeiten mit Excel und Power BI

Author: Ignaz A. Schels

Publisher: Carl Hanser Verlag GmbH Co KG

ISBN: 3446456856

Category: Computers

Page: 345

View: 8971

Eine ordentliche Datenbasis ist die Grundvoraussetzung für jede Analyse. Lernen Sie, wie Sie hierfür den Abfrage-Editor in Excel, Power BI und Power Query (u.a.) optimal nutzen, um Daten aus verschiedenen Quellen einzulesen und zu modellieren. Das Buch zeigt mit zahlreichen Beispielen, wie Sie unterschiedliche Quelldaten flexibel und automatisiert anpassen, filtern oder zusammenführen. Mit steigendem Schwierigkeitsgrad werden zunächst die Werkzeuge und Techniken der Benutzeroberfläche und später die Feinheiten der zugrundeliegenden Abfragesprache „M“ nahegebracht. Aus dem Inhalt: - Grundlagen des PowerQuery-Abfrage-Editors - Abfragen auf Dateien, Datenbanken und Online-Quellen - Mehrere Datenquellen kombinieren - Komplexe Transformationen mit M - Über 400 M-Funktionen anschaulich erklärt - M-Funktionen selbst erstellen - Fehlerbehandlung und -vermeidung - VBA-Makros und M-Abfragen kombinieren - Abfragen effizienter und schneller machen Copy & Paste war gestern – wer heute Daten in ein Auswertungsmodell einliest, nutzt am besten eine automatisierte und standardisierte Lösung. Microsoft Excel (ab 2016 bzw. v16.0) und Microsoft Power BI Desktop enthalten hierfür den Abfrage-Editor, mit dem Sie eine Verbindung zu fast jeder Datenquelle herstellen können. In diesem Buch lernen Sie, dieses vielseitige „Programm im Programm“ zu nutzen, um Ihren Datenimport zu automatisieren: Nicht nur das Einlesen, sondern auch die komplexe Datenaufbereitung wird einmalig als Abfrage gespeichert und kann anschließend immer wieder ausgeführt werden. Grundlage ist die Technologie Power Query, die zuerst als Add-In für Excel 2010 entwickelt wurde, und nun fester Bestandteil der neuesten Versionen von Excel und Power BI ist. Dank der benutzerfreundlichen Oberfläche des Abfrage-Editors lernen Sie schnell, Daten aus verschiedenen Quellen einzulesen und einfache Transformationen wie Filtern, Gruppieren oder Ersetzen durchzuführen. Für komplexe Transformationen greifen Sie auf die integrierte Abfragesprache zurück, die unter dem Kürzel M bekannt ist (offiziell Power Query Formula Language). Mit präzisen Erklärungen und anschaulichen Beispielen hilft Ihnen dieses Buch, das volle Potenzial von Power Query auszuschöpfen und Abfragen in M zu schreiben wie die Profis.
Computers

Microsoft Business Intelligence For Dummies

Author: Ken Withee

Publisher: John Wiley & Sons

ISBN: 9780470606346

Category: Computers

Page: 432

View: 5479

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

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: 9109

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

PowerPivot for Business Intelligence Using Excel and SharePoint

Author: Barry Ralston

Publisher: Apress

ISBN: 143023380X

Category: Computers

Page: 304

View: 8410

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

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: 2745

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

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: 1398

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

Excel 2007 VBA-Programmierung für Dummies

Author: John Walkenbach

Publisher: Wiley-VCH

ISBN: 9783527704118

Category: Computers

Page: 385

View: 5768

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 2002 für Dummies

Author: Greg Harvey

Publisher: Wiley-VCH

ISBN: 9783527700523

Category: Computers

Page: 352

View: 7372

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 2016 für Dummies

Author: Greg Harvey

Publisher: John Wiley & Sons

ISBN: 3527802304

Category: Computers

Page: 389

View: 8375

Excel-Tabellen leicht gemacht Man denkt zuerst an Excel, wenn man an Tabellenkalkulation denkt. Greg Harvey stellt Ihnen in diesem Buch die neue Version von Excel 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

Excel 2016 Formeln und Funktionen

Über 450 Funktionen, jede Menge Tipps und Tricks aus der Praxis

Author: Ignatz Schels

Publisher: Carl Hanser Verlag GmbH Co KG

ISBN: 3446448381

Category: Computers

Page: 671

View: 1174

Die Funktionsbibliothek kennen und beherrschen - über 450 Funktionen, eingeordnet in 12 Kategorien Über 450 Funktionen bieten alle Voraussetzungen für professionelle Kalkulationen und Verknüpfungen. Wie diese konstruiert, verschachtelt und raffiniert kombiniert werden, zeigt dieses Buch. Die volle Excel-Power nutzen - Mehr als 100 Beispiele aus der Praxis demonstrieren, wie es geht und wo die Funktionen passend zum Einsatz kommen. - Der Leser lernt auch wichtige Techniken im Funktionsumfeld wie Bereichsnamen, dynamische Bereiche und die effektivsten Methoden der Fehlersuche kennen.
Computers

Building Dashboards with Microsoft Dynamics GP 2016

Author: Belinda Allen,Mark Polino

Publisher: Packt Publishing Ltd

ISBN: 1786464047

Category: Computers

Page: 354

View: 4266

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

SAS Business Intelligence for the Health Care Industry

Practical Applications

Author: Renu Gehring

Publisher: SAS Institute

ISBN: 1612903231

Category: Computers

Page: 205

View: 2874

SAS Business Intelligence for the Health Care Industry: Practical Applications teaches health care executives, managers, providers, and business analysts how to use SAS Business Intelligence (BI) tools to convert data into knowledge and value at all levels in the health care industry. This book demonstrates how SAS BI solutions can be applied to the health care industry and offers detailed explanations of code and tasks in an approachable case study format. All applications are created with sample data that has the richness and complexity of operational health care data. With its level of depth and perfect blend of technology and business contexts, this book provides health care analysts, researchers, and statisticians with information and examples that can be used effectively and immediately. It is an indispensable aid to the health care professional in keeping up with a fast-changing industry.