text:
SQLBI - Marco RussoSQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
 You can follow me on Twitter: @marcorushttp://sqlblog.com/blogs/marco_russo/atom.aspxCommunity Server2015-11-17T09:55:00ZLeverage Analyze in Excel for your Power Pivot modelhttp://sqlblog.com/blogs/marco_russo/archive/2016/04/25/leverage-analyze-in-excel-for-your-power-pivot-model.aspx2016-04-25T11:00:00Z2016-04-25T11:00:00Z
Microsoft recently released the Analyze in Excel feature, which allows you to connect an Excel pivot table to a data model published on Power BI. I think/hope that Microsoft will enhance this feature to extend its current limits. For example, it does not allow you to connect a live model based on an on-premises SSAS Tabular server through Power BI Enterprise gateway. However, this feature is also very interesting to any Power Pivot user.

When you have a data model in Power Pivot, you have to create all the reports within the same Excel workbook. At the end, you have a single file containing everything: the data model, the data, and the reports. This is fine at the beginning, but as soon as you create more complex data models, you increase the number of reports – in a word, when the model grows – then you face a few problems. Any edit operation of a power pivot model could require time to refresh pivot tables and measures. The editing experience becomes slower. You cannot separate the data from the reports in two different files to split maintenance responsibility. If you created several reports based on the same power pivot data model, you already know this story. It would be nice to split the data model (and the data) from the reports. Now you can, using Power BI and the Analyze in Excel feature. Power BI is your best friend here.

This is the list of the operations you have to do:

Download and install Power BI Desktop – you have to be a local administrator of your machine to do that, but this is the only step requiring such a permission.

Open Power BI Desktop.

Import the Power Pivot data model in Power BI Desktop using the feature File / Import / Excel Workbook Contents, and then schedule a refresh if you need that.

Publish the Power BI Desktop data model in Power BI service

Open the data model from Excel using the Analyze In Excel feature on Power BI service

Create the same reports you had in the original Excel file using new pivot tables.

At the end, you will have an Excel file connected to an external data model, which can refresh automatically through a schedule you control. Before Power BI, you had to use Power Pivot for SharePoint to do that.

You might ask why I am not suggesting to publish the Power Pivot data model straight to Power BI service, without creating a Power BI Desktop file to do that. The reason is that it is much simpler to work with two separate files, and the environment in Power BI Desktop provides you the ability to use bidirectional filter in relationships, a feature that is not available in Power Pivot for Excel. However, this approach requires you to plan in advance the moment you "detach" the data model from Excel if you defined synonyms for Q&A.

At the moment of writing, you cannot modify synonyms in Power BI, neither in Power BI desktop nor in Power BI service. However, if you created synonyms in Excel, they are kept in the data model in Power BI Desktop, even if you cannot modify them (by now, I hope!). If you want to modify the synonyms for Q&A in the Excel file, you have to repeat the cycle and import the Power Pivot data model again in Power BI, losing the changes you might have done before. I am not saying that this way of working should be suggested to anyone, but you might be interested if you are willing to pay the maintenance cost of this solution, which already provides you the best of the two worlds: define synonyms for Q&A in Power Pivot, and create relationships with bidirectional filter in Power BI Desktop. When editing synonyms will be possible also in Power BI Desktop and/or in Power BI Service, this article will become immediately obsolete.

At the moment, you should consider that changing the synonyms in Power Pivot will require you to overwrite the changes you applied to the data model in Power BI Desktop. Thus, you might want to apply any change to the data model in Power Pivot (for example, adding/removing columns/measures) instead of using Power BI. You might just apply bidirectional filter on Power BI, but you will have to repeat that every time you import the data model in Power BI Desktop from Excel again. And you would lose any report designed in Power BI Desktop doing that, so you should edit reports in Power BI service only… Editing synonyms in Power BI will definitely streamline the process, when it will be possible.

One feature that I would like for this scenario is being able to change automatically all the connections of the pivot tables based on a Power Pivot data model, replacing the correspondent connection string in the ODC file returned by Power BI clicking on Analyze In Excel. This is also a long awaited feature for those who want to publish a Power Pivot data model to an on-premises Analysis Services Tabular server, and it is not easy to manipulate the file so that you can refactor the connection string in all the queries of the dataset. I am sure that this would improve the productivity of Excel users facing this issue, and it will increase the number of users or Power BI service.

Conclusion

You can use synonyms today in Q&A, but you have to create and edit the model in Power Pivot, exporting it to Power BI only to edit relationships using types not available in Power Pivot (such as the bidirectional filter).
sqlbihttp://sqlblog.com/members/sqlbi.aspxA warm welcome to Power BI Embedded #powerbihttp://sqlblog.com/blogs/marco_russo/archive/2016/04/07/a-warm-welcome-to-power-bi-embedded-powerbi.aspx2016-04-06T22:12:00Z2016-04-06T22:12:00Z
I wrote this blog post with Alberto Ferrari.

A few days ago, during the Build conference, Microsoft announced the availability, although still in preview, of Power BI Embedded. In a few words, Power BI Embedded lets you embed Power BI reports in your application, taking advantage of the tools in Power BI to enrich the analytical power of your application. Users do not have to authenticate with the Power BI service. In fact, they do not even need a Power BI account. Your application performs the necessary steps to authenticate a user and then, it uses App Tokens to request for report rendering. App Tokens are generated by the Power BI service when your application requests them, providing the necessary keys associated with your Azure subscription.

Power BI embedded is priced using renders. Currently, the price is 2.50 USD per 1,000 renders, and the first 1,000 renders in a month are free. A render is the production of a visual in a report, so a single report requires one or more renders (a dense report will be more expensive).

The first step to use Power BI Embedded is to activate the service in Azure, by means of creating a Power BI Workspace Collection. A workspace collection, as its name implies, is a set of workspaces. A workspace can contain datasets, reports and dashboards, same as it is happening today with the Power BI workspaces you work with when you are connected to the Power BI service.

You can add items to a Power BI Embedded workspace by uploading a PBIX file generated with Power BI Desktop. Connection strings, data model, measures and calculated columns, visual interactions and all other functionalities of Power BI are uploaded along with the model and available for your reports. This is, at least, the experience during the preview. As soon as the product reaches general availability, the development experience might be different and, as of today, there are no information about how it will work when released (hopefully you will be able to automate the creation of the model and its data refresh). Nevertheless, in this early phase, the option of using Power BI Desktop for development is awesome, as it leverages a well-established technology to author the reports, although it means that – as of today – you cannot add a dashboard to a workspace collection, because Power BI Desktop does not have a dashboard authoring feature, it stops with reports. Another limitation that exists during the preview is that you cannot refresh data, unless you upload a new version of the PBIX file. If you need to work with live data, today the only option is to leverage DirectQuery connections, along with all the limitations that come from that.

Once the workspace collection is in place, your application needs to connect to the service and generate an App Token by providing the needed key (which you have to store in the application itself). Once the application has an App Token, it can interact with the user the way it needs and, when it is time to produce a dashboard, it provides the App Token to the service again requesting the rendering of one or more reports. Power BI takes care of handling the report rendering and visual interactions.

In order for the entire reporting system to work, the Power BI service needs to be able to connect to the data source. This can be very easy, if the data source is already in the cloud, or it requires some additional refreshing steps if the data source is on premises and not connected to the service. In such a case, you have to publish to the Power BI cloud service an updated version of the PBIX file using the Power BI Embedded API.

So far, so good, it looks like Microsoft created yet another library to show dashboards inside an app. Why do we believe this is huge, not just yet another reporting app?

It uses the very same tools your users are probably using in Power BI to gather insights.

It does not have a starting price: you pay for what you use. The more customers are using your application, the more you pay for. By using a similar approach (pay per use) you can limit the initial investment to build a real analytical system in your application

It does not provide you a simple reporting tool. It provides a modeling tool where you build a data model through a Power BI Desktop file, along with measures, ETL steps with Power Query, calculated columns and tables. Thus, in order to provide analytics to your application, you do not need to focus on how to build a given report. Instead, you will focus on how to build an analytical model on top of which, later, you will build reports.

This latter change is, in our opinion, the most important of all. A simple shift in the way you think at reporting inside an application might open a whole bunch of new features and help democratizing Business Intelligence. For example, it is easy to think at standard reporting provided inside the application and, for advanced users that require more power, ISV can provide Power BI Desktop files that can be customized and later deployed on Power BI to perform custom analytics.

It is important to note that this preview is not a complete solution for any ISV. Today there are no APIs to programmatically create a PBIX file. This results in strong limitations for automating the creation of a custom data model depending on parameters defined by the application created by the ISV. An API to create a PBIX file or to manipulate a data model published on the server would be an important advancement to create a fully functional ecosystem for the ISVs. We hope this is only the first step in that direction.
sqlbihttp://sqlblog.com/members/sqlbi.aspxHow to fix #dax time intelligence functions in #powerbi when date table uses a surrogate keyhttp://sqlblog.com/blogs/marco_russo/archive/2016/03/07/how-to-fix-dax-time-intelligence-functions-in-powerbi-when-date-table-uses-a-surrogate-key.aspx2016-03-07T09:16:00Z2016-03-07T09:16:00Z
I wrote an article about  Time Intelligence in Power BI Desktop to explain how to fix measures using DAX functions for time intelligence when you have a data model where the relationship uses surrogate keys. THe short description is that all the time intelligence functions in DAX makes two assumptions: you have a "full" date table (all days for each year you want to handle must be present), and you use the "Mark as Date Table" setting to identify the date column in a date table. However, the latter is not possible in Power BI Desktop, because such a setting is not available yet (end of February 2016).

There are a number of workarounds possible when we wait for such a feature in a future version of Power BI Desktop. This problem has a limited impact because, when you use the date column in the relationship, the "Mark as Date Table" setting is not strictly necessary. However, it is a good idea to understand why this behavior exists and how the settings affect the DAX engine by reading the article, even if you don't have this problem today.
sqlbihttp://sqlblog.com/members/sqlbi.aspxPossible #powerpivot issue removing Excel 2016 going back to Excel 2013http://sqlblog.com/blogs/marco_russo/archive/2016/02/29/possible-powerpivot-issue-removing-excel-2016-going-back-to-excel-2013.aspx2016-02-29T11:05:00Z2016-02-29T11:05:00Z
Today I observed an issue on a notebook where Excel 2016 was installed and then removed, going back to Excel 2013.

After this operation, workbooks having a Power Pivot data model were working correctly by navigating data in PivotTables, but any operation in the Power Pivot window (such as adding columns, tables, or editing measures) was failing. The error was a TYPE_E_CANTLOADLIBRARY and it was caused by a type library not removed uninstalling Excel 2016.

I solved the problem by removing the following key from the registry

[HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}\1.9]

 (WARNING: DON'T TOUCH THE WINDOWS REGISTRY IF YOU DON'T KNOW WHAT YOU ARE DOING - use the following link to get more detailed instructions and always do a backup first).

I found this article that describes the problem as a possible issue in all the versions of Excel!
sqlbihttp://sqlblog.com/members/sqlbi.aspxNew features in Power Pivot Utils v 1.05: list unused columns #powerpivot #daxhttp://sqlblog.com/blogs/marco_russo/archive/2016/02/16/new-features-in-power-pivot-utils-v-1-05-list-unused-columns-powerpivot-dax.aspx2016-02-16T14:20:00Z2016-02-16T14:20:00Z
The latest version of Power Pivot Utils v 1.05 has a new feature that deserves the immediate upgrade: you can list unused columns!

Thanks to Idan Cohen and Amir Hefetz for their contribute to the macros developed by Bertrand d'ARBONNEAU!
sqlbihttp://sqlblog.com/members/sqlbi.aspxGROUPBY vs SUMMARIZE in #dax #powerbi #powerpivothttp://sqlblog.com/blogs/marco_russo/archive/2016/02/15/groupby-vs-summarize-in-dax-powerbi-powerpivot.aspx2016-02-15T06:55:00Z2016-02-15T06:55:00Z
If you are using Power BI Desktop or Power Pivot in Excel 2016, you should learn when and how you can use GROUPBY instead of SUMMARIZE. The SUMMARIZE function is very powerful and internally very complex, so it's easy to find scenarios where you get unexpected results or you have performance issues. The new GROUPBY function (also available in SSAS Tabular 2016) can be a better choice in a number of cases, even if it's not the same and, for example, it does not "enforce" a join as you can do using SUMMARIZE (see here for more details).

I recently wrote an article about one situation where GROUPBY is absolutely the best choice: when you have nested grouping. An example is pretty simple: you want to SUMMARIZE the result of another SUMMARIZE… well, it's not possible, but you can do that using GROUPBY.

Once you get used with GROUPBY, I also suggest you to check your skills with the DAX Puzzle about GROUPBY we published a few weeks ago. And if you alread solved it, try the new puzzle published less than two weeks ago about "last date" – not related with groupby behavior, but still good food for mind!
sqlbihttp://sqlblog.com/members/sqlbi.aspxConferences and Training in Australia Feb/Mar 2016 #dax #sqlsaturdayhttp://sqlblog.com/blogs/marco_russo/archive/2016/02/01/conferences-and-training-in-australia-feb-mar-2016-dax-sqlsaturday.aspx2016-02-01T02:09:00Z2016-02-01T02:09:00Z
In a couple of weeks, I will move to Australia for 3 weeks, visiting Melbourne and Sydney for a number of events and training. This is the list of topics in public events you can attend (with link to registration pages – remember that SQL Saturday conferences are free events, but you still have to register first!):

UPDATE 2016-02-08 - added a session on Feb 16 in Melbourne!

MELBOURNE

16 Feb, 2016 NEW– SSAS Tabular from the Trenches (Australian SQL Server User Group)

19 Feb, 2016 – Power BI inside-out (Pre-Conference Day of SQL Saturday #464)

20 Feb, 2016 – Toolkit for DAX Optimization (breakout session of SQL Saturday #464)

22-24 Feb, 2016 – Mastering DAX Workshop (3 day classroom)

SYDNEY

26 Feb, 2016 – Power BI inside-out (Pre-Conference Day of SQL Saturday #468)

27 Feb, 2016 – Toolkit for DAX Optimization (breakout session of SQL Saturday #468)

29 Feb-2 Mar, 2016 – Mastering DAX Workshop (3 day classroom)

3-4 Mar, 2016 – Optimizing DAX Workshop (2 day classroom)

You can follow the links to see more detailed info about each event. Please note that early bird discounted price for Mastering DAX and Optimizing DAX workshops will expire at the end of this week (Feb 6) – if you are in Australia (or close enough) and you don't want to miss these unique dates for an immersive DAX training, hurry up and get the discounted price!

I really look forward to come back in Australia!
sqlbihttp://sqlblog.com/members/sqlbi.aspxCreate static tables in Power BI, Power Pivot, and Analysis Services #powerbi #powerpivot #ssas #tabularhttp://sqlblog.com/blogs/marco_russo/archive/2016/01/26/create-static-tables-in-power-bi-power-pivot-and-analysis-services-powerbi-powerpivot-ssas-tabular.aspx2016-01-26T11:57:00Z2016-01-26T11:57:00Z
I recently wrote an article about how to Create Static Tables in DAX Using the DATATABLE Function. Such a new DAX feature (the DATATABLE function) will be likely used in the upcoming Analysis Services Tabular 2016, but it is not used neither in Power BI nor in Power Pivot to create static table. For this reason, I think that it could be useful to do a quick recap of all the methods available if you need a table with fixed static data in your data model.

Power Pivot

Linked Tables: you can create a table in Excel with static data and import it in a data model using the Linked Table feature. However, this is technically not a "static" table, it can be refreshed with new data and the table in Excel can be dynamic, as shown in the article describing the "Linkback Tables in Power Pivot for Excel 2013".

Paste data from Clipboard: if you copy a table in the clipboard and paste it in Power Pivot, the data model has a correspondent table that also contains data definition in model metadata. You cannot modify the content later, unless you use the Paste Replace feature of Power Pivot. Technically, the content is included in the XML defining the data model, but you do not have any access to it in Power Pivot.

Power BI Desktop:

Enter Data: the Enter Data feature in Power BI Desktop allows you to enter data manually in a table, and you can also paste data from the clipboard using this user interface, which allows you to modify the content of this static table later, after the paste operation. The content is stored in a string using a compressed and encoded JSON format. Such a string is extracted in an M transformation using calls to nested calls Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(…))))

Calculated Table using DATATABLE function: you can also create a calculated table using DATATABLE, as explained in the article I previously mentioned.

Analysis Services 2012/2014/2016 (until model version 1103):

Paste data from Clipboard: similar to what you do in Excel Power Pivot. The only difference is that you can modify the static content defining in the data model by manipulating the .BIM file with a text editor. The content of the table is defined in an XML schema.

Linked Tables imported from an Excel data model: they are defined in the data model exactly as you would define a static table using Paste Data from Clipboard feature.

Analysis Services 2016 (from model version 1200):

Paste data from Clipboard: such a feature is not yet implemented (in CTP 3.2) and you get the error message "TOM does not yet support pushed tables" if you try to execute it. Because the model version 1200 does not store data in XML, I **suppose** they will implement the static table as a calculated table using the DATATABLE function, just as you might already do manually in Power BI Desktop. I will update this blog post later when a new CTP or RTM will support such a feature.

I hope this schema will help you making a decision about the technique to use in this scenario.
sqlbihttp://sqlblog.com/members/sqlbi.aspxPower Pivot Utils: a nice collection of VBA macros #powerpivot #daxhttp://sqlblog.com/blogs/marco_russo/archive/2016/01/19/power-pivot-utils-a-nice-collection-of-vba-macros-powerpivot-dax.aspx2016-01-19T11:50:00Z2016-01-19T11:50:00Z
When you use Power Pivot, there are a number of operations requiring more than one click (or much more than just Excel):

Creating a pivot table based on the current data model (at least 2 or 3 clicks)

Create a table of existing measures (including its DAX expression)

Create a table of existing calculated columns (including its DAX expression)

Format with DAX Formatter the DAX expressions you extracted from measures and calculated columns (one copy/paste operation each)

Display memory usage by table and column (you can use VertiPaq Analyzer, which provides a lot of detailed information, but you have to restore the data model in Analysis Services to use it – or you can use some VBA macro, but it's still more than one-click if you have to copy the macro)

The good news is that a student I had in Paris at a Mastering DAX workshop invested time to create a collection of VBA macros that are shown to the user in a clean and nice ribbon called Power Pivot Utilities.

When I've seen this ribbon, I thought it is so useful that it should be shared to a wider audience, so I asked to its author, Bertrand d'ARBONNEAU (firstname.lastname@example.com) how to do that. After a short conversation, we decided to publish it on SQLBI, so you can already download Power Pivot Utilities from the Tools section. We will keep the version on the web site up to date when Bertrand will release fixes and updates.

I am pretty sure many people will appreciate this tool: enabling VertiPaq Analyzer on Power Pivot is a top requested feature, and this tool is a nice replacement waiting for a major upgrade to VertiPaq Analyzer, which require a longer work.

Kudos to Bertrand for his job!
sqlbihttp://sqlblog.com/members/sqlbi.aspxPerformance issues related to security roles in Analysis Services Tabular #ssas #tabularhttp://sqlblog.com/blogs/marco_russo/archive/2016/01/13/performance-issues-related-to-security-roles-in-analysis-services-tabular-ssas-tabular.aspx2016-01-13T13:15:00Z2016-01-13T13:15:00Z
I have experienced (on difference customer's databases) some performance issues related to security in SSAS Tabular models. The symptoms are that certain queries, pivot table, or reports, have good performance when you connect as a database administrator, but end users see bad performance no matter what selection and filter they use.

I wrote an article, Security Cost in Analysis Service Tabular, which explains how security is implemented and the different techniques that could be used, depending on the size (number of rows) of tables involved. It's a tough start of the year, it is certainly not an "easy read", but I wanted to write the information that will help me (and many others!) to remember what is going on and to evaluate possible solutions.

In my experience, a common situation is a star schema where you apply security on many dimensions. Such approach will create multiple joins in the storage engine queries generated for any measure, because rows in the fact table have to be filtered according to the security, even if the dimension is not included in the filters of the report. There are no silver bullets for this issue, specific optimizations might vary depending on specific data volume and security rules. However, knowing where is the problem is always the first step towards the solution.
sqlbihttp://sqlblog.com/members/sqlbi.aspxCreate DAX measures with a session's scope #dax #ssas #tabularhttp://sqlblog.com/blogs/marco_russo/archive/2016/01/11/create-dax-measures-with-a-session-s-scope-dax-ssas-tabular.aspx2016-01-11T12:35:00Z2016-01-11T12:35:00Z
This short blog post is a note that could help myself in the future, or anyone who is interested in writing a client tool for Analysis Services.

When you establish a session to Analysis Services, you can run both DAX and MDX statements. In DAX, you can create a measure that is local to a query by using the following syntax:

DEFINE MEASURE Sales[Sales Amount] = SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] )

You have to execute this statement every time you run the same query, even when you do that within the same session.

If you have administrative permission, you might deploy such a measure to the data model, but this would affect all the users and is not interesting in the scenarios I'm considering. However, you can use a mix of MDX and DAX syntax to create a measure that has a session scope:

CREATE SESSION MEASURE Sales[Sales Amount] = SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] );

You might expect this syntax to work only in MDX statements, but it works also in any following DAX query within the same session.

As you might imagine, this is an interesting idea to "inject" measures in an existing report. I originally evaluated this approach to create DAX measures for an Excel PivotTable connected to Analysis Services Tabular. However, the "MDX Calculated Measure" feature in Excel cannot be used for this purpose, because they require MDX syntax in the measure definition.

Maybe some other tools/developers will find this information useful.
sqlbihttp://sqlblog.com/members/sqlbi.aspxThe State of Power BI #powerbihttp://sqlblog.com/blogs/marco_russo/archive/2015/12/21/the-state-of-power-bi-powerbi.aspx2015-12-21T14:35:00Z2015-12-21T14:35:00Z
The 2015 has been an amazing year for Power BI. One year ago, I was commenting on this blog the public preview of Power BI dashboards. A few days ago, Microsoft released the December update of Power BI Desktop and several updates of the Power BI service. In one year, we moved from a situation where Microsoft seemed (and actually was) too slow in the BI market, to a weekly (and sometimes daily) wave of announcements that are becoming hard to follow also for those enthusiast early adopters (but don't misunderstand and read my lips: D O N ' T   S T O P   R E L E A S I N G   N E W   F E A T U R E S !!).

It's clear that Microsoft is moving quickly to get the cloud market of BI services, which is still unexplored (after all, most of the companies keep their data on premises), but it is the only player providing a credible story of integration between cloud and on premises BI services (see "The Box is Back" and "Happy Together" pictures used at last PASS Summit). I finally see both strategy and execution working together. And execution is happening at the right speed, which has to be very fast nowadays.

There are a long number of features, improvements, technical details, and future directions that justify this analysis, but there is still a long road ahead before good comments become actual revenues and adoption in production. However, there are key changes I have seen in this year that strongly support a positive outlook for the entire Microsoft BI stack of technologies:

No more "by design" answer: first and foremost, the entire Microsoft BI team removed the "by design" answer for bug/suggestions submissions. The Power Query team started with this positive attitude of considering feedback as something to use for real. Now the entire Microsoft BI team listen to the community, consider feedback and prioritize features based on comments received. Don't underestimate this point. This, and an increased transparency, is the foundation of the credibility that leverages the word of mouth and community support. Other Microsoft products don't have this asset, and they should do something to get it. Microsoft is behaving as a startup here, and the results are visible. One year ago, this was a promise. Today, it is a fact.

Constant and continuous innovation: weekly and monthly releases creates a push to keep the software up-to-date. This impacts in particular Power BI Desktop, and backwards compatibility is no longer a constraint for innovation. There are pros and cons in this, but by now there are more goods than bads.

DataZen acquisition: I've seen many comments that were not convinced about this move, because it was creating confusion and overlaps with other Microsoft products. Now that Microsoft released SQL Server 2016 CTP 3.2 that includes the first version of DataZen (now named "mobile report type") in Reporting Services, most of these considerations are over. However, I always thought that DataZen acquisition was an excellent strategic move. Microsoft bought a fast-growing company that was not quoted, including the technology and the development team in a single move. While most of the comments were about the effective value of the technology and the overlap between DataZen and Power BI mobile app, my appreciation was more about buying a company to remove it from the market, so that other possible big competitors wouldn't have been a chance to buy it. Doing that when the company was mature enough to have a real customer base (and a real working product), but small enought to not be under the radar of many analysts, is an additional bonus. Great move.

Custom visuals in Power BI: disclaimer: I might be biased for having inspired the creation of Synoptic Panel. But I think that making the visual components an open source part of Power BI and enabling a large community to contribute to a public gallery is a super smart move. If the community contributes, this is good. But even in case the community would not respond, Microsoft opens a door to release part of software complementing its product (Power BI), without requiring the cost related to official release of software (which higher costs are internationalization and documentation). Think about the cost of releasing and supporting softare in hundreds of languages (think to Office) and you should quickly realize why this move is smart. Not to mention the number of opportunities that it opens to Microsoft partner, leveraging the existing ecosystem.

Adoption or "R": Is the support of the "R" language really required for a tool like Power BI? Let me say an unpopular opinion: there are too many buzzwords in the BI arena, and it's not the first time. It has been always the same, just changing the buzzwords. We started with DSS (Decision Support Systems), we recently heard about big data, I've seen that BA (business analytics) rocks more than BI (business intelligence), you cannot live without a data scientist, and yes, you need "R" in your company. The list could continue for pages. But is this really true? I am convinced that "R" is very good in certain domains, and at the same time I see it used (or even just considered) also when it is completely useless. But I am a consultant, I don't sell licenses, I help customers building solutions that actually work, possibly reducing development cost and time. "R" is an option, but is not necessarily important or relevant in many scenarios. But can Microsoft ignore the important of buzzwords and trends in the market? Absolutely no. So adopting "R" for data sources and visualizations (see latest announcement for R Visuals in Power BI) is another great move that will help Microsoft sales (and this is true for all Microsoft partners, too).

I have seen in one year a multiple of what I have seen in the previous ten years. In reality, Microsoft is leveraging many assets that were already in-house (the Tabular engine, Power Pivot, Power Query, Power View, and many other Azure's based services), which development required several years. But the weak point has always been the "last mile" of data visualization and presentation. Other players were years-ahead in this area. And I think they are still ahead of Microsoft. You might have a scenario that already fits well with Power BI. Maybe your scenario will be "Power BI" friendly in a few months. But the trend is clear and the improvement is continuous. So, when I think to the considerations I will do in 12 months, I am very positive and I am also scared about the number of new features I have to learn. Since this is what I (probably we) asked for many years, I cannot complain!

I always take a look at stock price of companies to check whether financial results and expected outcomes correspond to my point of view. Unfortunately, it's not fair to compare Microsoft with other specialized companies that work only in the BI market. So we cannot draw any conclusion by observing that Microsoft (MSFT) is at its highest point since Tableau IPO (DATA), whereas Qlik (QLIK) didn't add much value to stockholders in the last 3 years (source: http://www.nasdaq.com/symbol/msft/stock-comparison).

What can we expect in 2016? I expect Power BI to continue its growing as data visualization platform, ecosystem, and adoption. However, the upcoming Microsoft SQL Server 2016 will be a huge release for the BI services. It will be the more important release since 2005, and this is mainly because of the new SQL Server Reporting Services (see Microsoft Business Intelligence reporting roadmap to read more). In reality, also SQL Server Analysis Services is a very important release, being the first major upgrade since SQL Server 2012 for Analysis Services Tabular (see latest announcements for SQL Server 2016 Analysis Services CTP 3.2).

Without going in detail, there are many new features that will make Tabular a more "enterprise ready" platform. It's not that the current version is not good, I helped many companies in succesful adoption of Tabular, but there are many improvements in productivity and performance that completely justify the upgrade even before considering new features available in the new version. There will be a lot to write about that, and I really look forward to start doing that in a few weeks.

The magic key will be "Hybrid BI". It's already happening. I expect most if not all of the companies to move in an "hybrid" area for their BI solutions, where certain part are implemented on premises, and others in the cloud. And the reason to move on premises is not always preserving legacy investement, it could be requiring top performance of hardware for in-memory databases. For a certain size, you need to do an accurate hardware choice, where spending more is not necessarily better. In the very long term, I expect everything to move to the cloud, but the reality is that the two technologies will live together for a very long time, and Power BI is a good candidate to play a major role in this scenario.
sqlbihttp://sqlblog.com/members/sqlbi.aspxDisplay data on customized maps in #powerbi (also offline) leveraging SVG formathttp://sqlblog.com/blogs/marco_russo/archive/2015/12/15/display-data-on-customized-maps-in-powerbi-also-offline-leveraging-svg-format.aspx2015-12-15T12:35:00Z2015-12-15T12:35:00Z
Last week Amir Netz presented in the Power BI blog a detailed introduction to the Synoptic Panel written by Daniele Perilli. This component won Power BI best visual contest in October, but since then we received many feedback and Daniele worked on it improving the editor and the available features. The big news is that now the Synoptic Panel supports the SVG format. You can still start from a bitmap and draw areas you want to bind to data in Power BI, but now the result of this job is an SVG file created by the Synoptic Designer. Graphical features of the designer are limited, so if you want a real arc, circle or complex shapes, you can create an SVG file with an online editor (such as http://editor.method.ac/ – but you can find many others) and then import it in Synoptic Designer. Since the SVG includes areas, the designer simply import these entities and allows you to edit their names.

Now, beside the technical details, why the impact of this feature is huge? Well, practically any vector format can be converted to SVG, so if you have a technical draw of a building, any planimetry built using a professional drawing software… chances are you can import them in Power BI now! But what if you don't think this impact you?

Well, you might need to display data on a map: by country, territory, state, city, district, whatever… Yes, we have Map and Filled Map components in Power BI, but they are good if you want to display the exact geographical details and if you are online. If you want to create custom areas, you want to remove certain details, or you want to use it also offline (or without Internet) using Power BI Desktop, you were unable to do that.

For example, if you want to display USA data by state, you might want to move Alaska and Hawaii in a different position in your map, such as in this example. And the good news is that you don't have to create this file from scratch: we imported this example from Wikimedia, which already has a good SVG format that you can import in Synoptic Designer: https://commons.wikimedia.org/wiki/File:Blank_US_Map.svg

The time you have to spend to create a new map depends on the quality of the initial file. The USA map is a very good example, because there is already one entity for each state, and each state has the 2-letter state code associated to it.

Go in http://synoptic.design/

Paste the URL of the SVG file (https://upload.wikimedia.org/wikipedia/commons/3/32/Blank_US_Map.svg) and click GET (or browse from your local drive if you have it there)

Now you will see in the editor all the states and selecting each one you will highlight the corresponding area on the right pane. You can type the complete name of each state here, or change the code to identify the state. You can store two names, one to bind data in Power BI and the other to display the name of the area in the visual (if blank, the same name used to bind data will be used by default).

You can also clear some area if you don't need it. If you want to change the drawing, you should edit the SVG file first in an external editor (such as http://editor.method.ac/). Please note that certain states in this specific map have an additional dash character you might want to remove.

Click EXPORT TO POWER BI button (bottom right), and then press the DOWNLOAD SVG button
22

If you find a good map that you think could be useful to other people, please click SUBMIT TO GALLERY, too! We already have a number of maps available, and you can quickly use them by navigating in Gallery / Country/Territory:

You can also browse the gallery directly from the Synoptic Panel component. Once you chose the map, you bind to Legend a column containing state names, to Values the measure to display (it will appear in the popup window by moving the mouse over a state), and to Saturation Values the measure that defines the saturation of the color (you can configure limits in Format properties). In the following example you see the Quantity measure used for both Values and Saturation Values, while the mouse is on Florida.

I really look forward to see new territories published in the gallery!
sqlbihttp://sqlblog.com/members/sqlbi.aspxUser group session in Amsterdam on Nov 26, 2016: Toolkit for #dax optimizationhttp://sqlblog.com/blogs/marco_russo/archive/2015/11/23/user-group-session-in-amsterdam-on-nov-26-2016-toolkit-for-dax-optimization.aspx2015-11-23T07:20:00Z2015-11-23T07:20:00Z
While I am teaching Mastering DAX and Optimizing DAX classes, I am always available to speech at local user group events. This week, I will present an updated version of the "Toolkit for DAX Optimization" in Amsterdam, on Thursday, November 26, 2016.

At this link you can register (for free) and see logistics details (user group event is after work, starting at 17:30 serving some food – presentations will start at 18:30 and I will speak at 19.00). Please note there are very few seats still available, so register only if you are sure to attend!

I already presented this session at PASS Summit 2015, but I will have more time and I'd like to show some more detail about how to use these tools with Power BI, too. And, of course, I will be open to Q&A!

This is the description of the content of this session.

Toolkit for DAX Optimization
How do you optimize a DAX expression? This session introduces you to useful tools to help measure performance, gather data to find the bottlenecks, and write new optimized versions of DAX. Starting from SQL Profiler, you learn which events are relevant for DAX and how to collect them in different environments (SQL Server Analysis Services [SSAS], Power Pivot, Power BI). Explore DAX Studio, which simplifies and speeds up the data-collection process and makes it easy to find bottlenecks in the storage engine and formula engine. The goal of this session is to provide a methodology to measure performance of your DAX measures, to find bottlenecks, and to identify the main reason of performance issues.

I will focus on tools more than on optimization techniques, but considering the very good feedback I received at PASS Summit, it seems the session works very well – I hope you will enjoy it, too!
sqlbihttp://sqlblog.com/members/sqlbi.aspxApply AND instead of OR logic to multiple selection in a slicer #dax #powerpivot #powerbihttp://sqlblog.com/blogs/marco_russo/archive/2015/11/17/apply-and-instead-of-or-logic-to-multiple-selection-in-a-slicer-dax-powerpivot-powerbi.aspx2015-11-17T07:55:00Z2015-11-17T07:55:00Z
I recently write a small article on SQLBI to describe how to create a DAX measure that search for items that have all the items selected in a slicer, instead of any of them. For example, you might want to create a measure that display how many customers bought at least one product for each of the categories selected in a slicer. You cannot change the behavior of the slicer itself, that applies a filter to the calculation, but using DAX you can iterate the selected items and make sure that each one exists in another set of items (such as the products bought by a customer). I think it could be an interesting technique also for different applications (I would be happy to read your ideas in the comments!). You can read the complete article on SQLBI.
sqlbihttp://sqlblog.com/members/sqlbi.aspx


text:
Is it Better to Skip Breakfast or Eat a Doughnut?
You're running late for work and first thing on the agenda is a big meeting. You meant to grab a banana and a yogurt on the way out the door but you were in such a rush, they are still sitting on your kitchen counter as you sit in traffic. You finally get to work and plop down in your chair, ready for the meeting, when your tummy starts to grumble.
"Look, everyone," one of your coworker says. "I brought doughnuts!
Normally, you'd politely say no thank you and opt for a healthier choice, but there's no other food in sight for the next few hours and your tummy will not shut up. So, should you eat the doughnut, or go hungry?

subset: commoncrawl


text:
Find more
RSS Reader
English (en)
English (en)
Русский (ru)
Українська (uk)
Français (fr)
Português (pt)
español (es)
Deutsch (de)
Italiano (it)
Беларуская (be)
Log in
Or connect using:
Forgot password?
Remember me
Log in
Create an Account
Your OpenID URL:
Log in
[Dept. Heaven World Guidance] → Dept. Heaven World Guide part 4 translation (+ news) - Disaresta
Official Site!
livejournal userinfo
journal archive
[Dept. Heaven World Guidance] → Dept. Heaven World Guide part 4 translation (+ news)
[Feb. 13th, 2010|
04:21 pm
knights in the nightmare
yggdra union
yggdra unison
Current Mood
Been a while, hasn't it? First of all, I've got a translation, and then there's some PSP!Knights and Yggdra Unison news to talk about.
The fourth section of the Dept. Heaven World Guide focuses on
Niflheim and the demons
rather than on any specific game, and provides us with background information on them. There may be minor spoilers for all three games, and Marietta's role in the series is alluded to all over the place, so take caution if you're a latecomer.
As always, I don't mind if you link to this post from everywhere on the planet, since this information's meant to be shared. But
credit me for the translation, and don't repost this stuff anywhere
Vol. 4: The World of Chaos, "Niflheim"
An infinite chaotic realm where the power of the gods does not reach: that is Niflheim. The truth may be wrapped in riddles, but there's no doubt that it's a myriad of worlds where all laws are thrown into chaos, and the common sense of Asgard and the surface worlds doesn't apply. However, it's the eternal reality of Niflheim that the strong stand above the weak, and because of the immense power of those called the demon gods, groups maintaining a type of order are often formed. In the past, the demon god with the greatest influence in Niflheim was known as its lord, and although the people of Niflheim were always longing for the opportunity to invade Asgard, only under the control of the lord of Niflheim did this come to fruition, and out of the lord's desire for control, "Ragnarok" began. Because the explosion of that instinctual desire was the trigger of war, the first invasions were carried out without any plans, but later both Niflheim and its directives became organized and attacked Asgard's army.
In the end they were defeated by the arrival of the "Grim Angels" in Asgard's army, but through the destruction of the gods, they made their true threat known to Asgard.
Demon Gods
"Demon god" is the title of those highest-ranked in Niflheim, possessed of high intellect and a kind of ideology (ambition); combined with their absolute power, this allows them to control their subordinates and command and organize large-scale groups. They match the gods of Asgard in competence, wisdom, and viewpoint of the overall situation, but their cohesiveness differs from the gods' in that it's not as though the demon gods carry the same views; in fact, it seems that the demon gods are always jockeying for power between themselves. Among the demon gods' supporters in Niflheim, it's exceedingly rare that any actually have a friendly attitude towards Asgard, but there are cases where they will support Asgard to further their own causes.
In Niflheim, it is possible for demon gods to lose their intelligence and fall to the place of Accursed, and also for the Accursed to amass power and become demon gods. This kind of reverse phenomenon is probably only possible in Niflheim, not within the immutable order of Asgard.
Demons on the Surface Worlds
The many so-called monsters arrive from Niflheim either by arriving themselves or by being summoned to the surface worlds using forbidden curses. Other than that, there are cases where beings of the surface world become demons either by falling under a demon's miasma or curse, or entering a contract with a demon god.
Hades Gate
Essentially, there are no ways to cross from Niflheim to the surface worlds but by using a Hades Gate. When those of Niflheim intend to easily infiltrate the surface worlds, they should pass through this Hades Gate, but because the construction ties two separate dimensions together, even if the "conceptual distance" between the chosen surface world and Niflheim is close, it isn't easy for the average demon god to open such a gate.
Niflheim as seen by Asgard
To Asgard, their understanding of the chaos of Niflheim is, of course, that it's a completely unpredictable place. Therefore, Asgard considers Niflheim to be dangerous, and usually orders its angels (like the Guardian Angels) to be on guard, hinder the construction of Hades Gates, and search for signs of interference. Even at the best of times, when construction of such a troublesome gate has received interference from Asgard, it becomes impossible even for powerful demon gods to act. However, once a Hades Gate is successfully opened, not just the surface worlds, but Asgard itself will take a lot of damage.
For the surface worlds, it's certain that Heaven's Gate—the opposite of a Hades Gate—exists, but when those are blocked off and destroyed by Niflheim, then those worlds are considered to have left Asgard's control and become part of Niflheim's domain. During Ragnarok, the construction and destruction of these gates was repeated, and the surface worlds were continually plundered and captured by one side, then the other.
Species Directory 4: Accursed
"Accursed" is a general term for those in Niflheim whose bodies carry immense power; it's a kind of title for the demons who rank just below the demon gods, not the name of a particular species. The Accursed are divided into two large groups; one is the followers of the demon gods with power close to theirs. The other is comprised of those who would be equals to or stronger than the demon gods, but are far less intelligent than them. The majority of the first type are created from the limbs of demon gods, much in the way the gods created the Grim Angels, or beings from completely different worlds who gained the power of the Accursed through contracts with demon gods, like the Archangel. The four Accursed sealed in Riviera are of the intelligent type who serve the demon gods.
Ito Shinichi's Dept. Heaven Secret Story, part 4
Because to form the series, creating information on Asgard's stance is prioritized over creating the surface worlds that make up the individual games' stages, Niflheim doesn't have many setting details and thus remains flexible; it transcends simple designations like "it's a place with a lot of bad guys" and is becoming something like a black box, a necessary evil. While formulating each stage and creating the worldview, the setting is such an important element that if flexible parts and masked information don't remain, actually creating new games would become incredibly difficult. If the created setting gets stretched too much, the game system might become really narrow, which I think might be putting the cart before the horse… Which is to say, Niflheim has been established as a kind of "last sanctuary" that can be used at the production's leisure. Because it has the image of "obscuring chaos", even if it's pinned down that way, not even the maker has to feel bad for using it like that.
Since we've talked a little about demons, I'll explain about "the enemies that appear in the games" a little bit. Basically I use the following logic to come up with the enemy designs based on the game system.
1. The battle system has limited-use weapons
2. We need a gimmick to reduce the number of uses
3. An enemy that seems like it could melt down weapons would be…
4. Slime monsters!
I decide it pretty simply. But the only reason I can use an approach like this is because of that conveniently created Niflheim. For instance, if it were very minutely established and Niflheim might have places like "a world in whose history slimes were driven away and made extinct" or "a world where slimes can only be bred by the demon god, so they're high-class pets", or even "a world where your wish will come true if you gather the seven slimes", then easily creating small-fry enemies and the other enemy characters would become impossible; it may actually be pretty problematic.
Next is the section on Knights in the Nightmare. It's going to take a while--Ito's textwall for that one takes up half a page, augh.
Anyway, on to other things. The
Knights in the Nightmare site
now features a countdown to a site renewal in which we'll (hopefully) be getting some actual content and more information on how the hell Ito's bringing such a DS-oriented game to the PSP.
Also, for those interested, Yggdra Unison's OST (with music composed by Adachi Minako and some arranged tracks by Hayashi Shigeki) will be available for purchase on the 24th of this month.
As has been rumored across the Internets, now it's been confirmed--a
drama CD
for Yggdra Unison is going to be released on March 25th! According to various websites, the CD will be divided into three sections of mini-dramas--some concerning the Royal Army, some concerning Milanor's thieves, and some concerning the Imperial Army (!!!). There will also be a bonus track with short commentary by the cast.
has the complete cast list and an image of the CD's cover, which is adorable. As expected of Kiyudzuki-sensei. About the cast, it seems as though all characters in the Royal Army will be appearing (along with the Flunky), but that the Imperial Army in its entirety will not be showing up--Gulcasa, the twins, Emilia, Baldus, and Eudy are listed, but no one else. None of the other characters seem to be appearing.
And I, predictably, am saddened by the lack of Nessiah. Yes, this damn book spends quite a bit of time discussing him, and Ito seems to like talking about him in conjunction with anything Yggdra Union-related, but Miyake Junichi did an amazing job as him, and Nessiah can never get too much attention. :C
At any rate, preorders for both the OST and the drama CD are available through Amazon.co.jp, in case anyone's interested! That's it for today.
2010-02-19 04:08 pm (UTC)
"In Niflheim, it is possible for demon gods to lose their intelligence and fall to the place of Accursed, and also for the Accursed to amass power and become demon gods."
"This kind of reverse phenomenon is probably only possible in Niflheim, not within the immutable order of Asgard."
...oh. Well then.
Great translations, btw.


text:
Joydeep Deb Search Story on Youtube. Check out my Google Youtube Search Story. Video duration only 35 seconds...
- Joydeep Deb
Joydeep Deb experienced in Online Marketing, Web Technologies, Search Engine Optimization, SEO, SEM, SMM, Web Master, eMail Marketing, Web Analytics, MIS Reporting, Web Design and Development.
Lives in Bangalore, Karnataka - India and working as an Program Manager SEO.
Get social with Joydeep at Twitter | Facebook | Google+ | LinkedIn
Receive my latest posts right in your inbox? Enter your email address below to subscribe.
Thank you for subscribing, you will be receiving our latest posts right in your inbox.


text:
In most cases, a good concrete job, public or private, will include sealing the service with some sort of an impenetrable stain (as well as simply caulking the joints)...that allows water run off, or bead on the surface.
So when you talk about creating thousands of permeable pavement holes to drain it--it just seems like it will never work. It brings back the idea of how much damage studded snow tires did to Wisconsin roads in the 1960's and 1970's when the "spikes" wore down the top layers exposing the aggregate. That is now one of the main reasons why our bridges fell apart, as the water leached down and expanded even down to the reinforcement steel.


text:
1 of 19
Posted by jmccoy on 06/18/2014 1:20am MDT tags: photos
LOS ANGELES — Breaking through against the Los Angeles Dodgers at Chavez Ravine is never easy, especially when Zack Greinke is on the hill. That's why the Rockies' oh-so-close moments were so maddening in Tuesday night's 4-2 loss to the Dodgers. The Rockies were just 2-for-14 with runners in scoring position, including 0-for-3 in the ninth inning.
Previous Post
Next Post


text:
Filter By:
Evacuation & Severe Weather Map Holders
Best Sellers
Emergency Evacuation Signs Map Holders: In Case Of Emergency Evacuation Exit Building - Immediately Report To Assembly Area
Available in glow-in-the-dark, ensuring people know where to go in case of and emergency.
Evacuation & Severe Weather Map Holder Clear Inserts
Easily print your own emergency map plans on either inkjet or laser printers.
Safety Sign: Severe Weather Map Holder
Plan and display a map of where to go for shelter during severe weather.
Custom Evacuation Map Holders
Holders & Displays are an easy way to hold and display signs to draw attention to your mes


text:
Board of Directors
The Board of Directors of the Fire Museum of Memphis leads the Museum along with the staff so that the mission of the Museum is accomplished. The Board meets once a month and includes a diverse group of individuals.
David Arick (Executive Committee Chair) - Assistant Treasurer, Global Risk, International Paper Co.
Tyler McBride (Co-Chair & Past Chair) - General Manager, State Systems
Eddie Floyd - (Vice-Chair) Managing Director, Kemmons Wilson Insurance Group
Susan Helms (Secretary) - Director Injury Prevention and Safe Kids, LeBonheur Children's Hospital
Kyle Hatler (Treasurer) - Vice President, Business Banking, Regions Financial Corp.
Richard Arwood (At Large) - Retired Director, Memphis Fire Dept.
Jeff Gaudino (At Large) - Vice President, Belz Enterprises
W. Ray Brakebill - Principal/ Owner, The Brakebill Co.
Mark Jowers - Founder of Cornerstone Carpet Care, LLC, dba ServiceMaster by Cornerstone (a franchise of ServiceMaster Clean and ServiceMaster Restore)
Mickell Lowery - Sales Executive, FedEx
Thomas A. Malone - President, IAFF, Local 1784
Tim McCullough, AIA- Architect, LEED Green Assciate, CM-BIM Urban ARCH Associates
Henry Posey - Retired Chief, Memphis Fire Dept./ Fire Chief, Atoka (TN) Fire Dept.
Dr. James E. Sexton, D.D.S.- Director, Christian Mobile Dental Clinic
Mary H. Tibbets - Vice President, Menard, Gates and Mathis, Inc.
Bobby Wharton - President, G&W Diesel and EVS MidSouth
Gina Sweat (Non-Voting Member) - Director, Memphis Fire Services
Michael Jubirt (Non-Voting Member) - Deputy Director, Memphis Fire Services
Joe Payne (Non-Voting Member) - Chief Fire Marshal, Memphis Fire Services
J. Kevin Walsh (Board Attorney) - Harris, Shelton, Hanover and Walsh, PLLC


text:
Key things you need to know aboutDr. Goel:
Phone & Address
Check insurance plans, locations and make an appointment
Accepting new patients?
- Yes
Dr. Goel's Offices
- Barrow Neurosurgical Associates, LTD
- Barrow Brain and Spine
- 3090 N 3rd Ave
- Phoenix, AZ 85013
(602) 456-7805
- (602) 745-2930
- Directions
7 Tips to Prepare for Your Appointment
The key to a successful appointment is communication. To get the most out of your visit, prepare ahead of time so you can lead the conversation with your doctor. These 7 tips will get you ready
Dr. Goel's Experience
Research training, expertise and qualifications
Dr. Goel's Care Philosophy
Dr. Goel's Specialties
- Physical Medicine & Rehabilitation
- View all 2 Specialties and 2 board certifications
Procedures Dr. Goel Performs
- Epidural Block
- Epidural Block, Facet Blocks
- See all 14 procedures
Conditions Dr. Goel Treats
- Extremity Injuries
- Failed Back Surgery Syndrome
- See all 6 conditions
More About Dr. Goel's Background
Hospital Quality
The right hospital is as important as the right doctor
- Dignity Health - St. Joseph's Hospital and Medical Center
- 350 W Thomas Rd
- Phoenix, AZ 85013
- HonorHealth Scottsdale Osborn Medical Center
- 7400 E Osborn Rd
- Scottsdale, AZ 85251
9 Facts About Hospital Quality
Patients' risk of dying during a hospital stay for heart bypass surgery could be 87.4% lower, on average, at a hospital rated 5 stars compared to a hospital rated 1 star for that procedure. Choosing the right hospital is critical to your health. View Slideshow
Patient Satisfaction
Patients' feedback on their experience with Dr. Goel
Likelihood of recommending Dr. Goel to family and friends is 3.7 out of 5 5 1 25
See More Survey Results
8 Facts About Patient Satisfaction Surveys
Patient satisfaction surveys provide a standardized way of reporting about healthcare experiences. But there can be more than meets the eye when reviewing scores. Here's what you should know
Oops, you entered a bad link for Dr. Goel!
The link you entered contains bad characters or identifiers. Please enter the link exactly as it appears in your email or text message.
Thank You
This confirms that we have received your survey about Dr. Goel. Please note: Your insights will help other patients make informed decisions. Please note: it may take 1 business day for your survey response to appear.
Thank You
Our records show that you have already confirmed your survey for Dr. Goel. Please note: it takes 24 hours for your survey results to show up on the doctor's profile.


text: Posted May 29, 2013 ..but I so want to be able to keep Jon Beason on this team. Such a great player/leader/dude. Listening to him on his episode of This is Gross, just amazed at him. Arguably one of most put together players in the league (mentally speaking). 2 people like this Share this post Link to post Share on other sites


text:
Welcome to dickblick
, null
not null?
Browse more:
These soft, smooth, velvety pencils can be mixed and blended to create an infinite spectrum of rich, vibrant colors.
They're ideal for a wide range of drawing styles, from bold contemporary still lifes and portraiture to finely detailed work — fashion illustration, animal portraiture, and landscapes.
The unique formulation is highly blendable and glides smoothly over a wide variety of drawing surfaces. They are acid-free and tested for lightfastness. Pencils are pre-sharpened.
Coloursoft Pencils, Skintone Set of 6
This set includes six specially selected skintone colors that are excellent for portraits and multicultural images, including Cream, Blush Pink, Pink, Ochre, Dark Terra Cotta, and Brown Earth.
Wood Box Set of 72
This beautiful hardwood box set contains the full range of 72 Coloursoft pencils and is a welcome addition to any artist's studio. The box measures 2"H × 16.25"W × 9.6"D (5 cm × 41 cm × 24 cm). Weighs 3.6 lbs (1.6 kg).
Shipping Note — Due to manufacturer distribution restrictions, Derwent products cannot be shipped to addresses outside of North America.
Set of 6
Set of 12
Set of 24
Set of 36
Set of 72
Wood Box Set of 72
® Derwent is a registered trademark.
Gift Idea
Hint — click a thumbnail to enlarge.
Hint — click a thumbnail to enlarge.
(based on 68 reviews)
Ratings Distribution
5 Stars
4 Stars
3 Stars
2 Stars
1 Stars
of respondents would recommend this to a friend.
Reviewed by 68 customers
Displaying reviews 1-10
Back to top
Previous | Next »
Great color pencils
By Donn Granros
from Elk River, MN
Comments about Derwent Coloursoft Pencils:
Great pencils,they do a great job and hold there points
Bottom Line Yes, I would recommend this to a friend
Was this review helpful? Yes / No
- You may also flag this review
Derwent Coloursoft colored pencils 72 pieces. Very Nice set
By BangorBill
from Bangor, Maine
I really like these colored pencils. They blend nicely and the colors are very nice. They really look nice when using 2 or 3 different colors to make a variegated flower. So pretty. I've used them on the last 2 pictures I've colored and am happy with them so far. They seem to sharpen easily and I haven't had any breakage yet. Just wish I'd have waited as I noticed they now are less expensive than when I ordered mine a couple weeks ago. If I didn't already have so many different types of colored pencils I would buy them again right now, but I'm running out of storage space.
Quality Pencils
By Karen
from Richmond, VA
I bought these for my 5-year-old grandson who is a wonderful artist already. I wanted him to have good quality pencils. He loves them. I also tried them, and they are creamy and have good colour.
Nice set
By Another Artist
from Ms
They are Derwent, what can I say, you can never go wrong with Derwent, the colors in this set are nice, I had to buy it. I love anything Derwent, my favorite brand of colored pencils.
(1 of 1 customers found this review helpful)
very nice
By hope this helps
from nj
The colors and softness of these pencils is very nice. The intensity of color transfer is comparable to Faber Castell Polychromos and Pablo by Caran D Ache but they may not be as light fast. I like these pencils very much as there are certain colors in this set I have not seen in other set such as sea green. Reds and oranges are very nice.
Adding to my collection
By SusanJane
from Santa Rosa, CA
Years ago I choose Der went over the most popular brand because I don't like my pencils to be so soft and waxy. Der went does vary between colors, some are softer, but in general they are what those fans call "scratchy." But I find that the popular brand must compromise their colors so they have a uniform consistency. Der went does not hide behind extra wax, they deliver top quality color every time. AND they don't break nearly as much. The few other pencils that I have break way more often. I'm not a professional. My coloring is primarily for rubber stamp images and mixed media in my artist journals. Over the years my collection has risen to over 60 pencils. I still prefer Der went.
(0 of 3 customers found this review helpful)
Great versatile art paper
By miss kris
from SLC, UT
I have a private teaching art studio and teach ages 4-adult. This is a great versatile student grade drawing paper. We use it mainly for graphite, chalk pastel, art markers and colored pencil. Once in a while I'm finding there may be an imperfection in the paper and grabs the medium in an undesired way leaving a darker spot.
Derwent Coloursoft Pencils
By Bev and Rhiannon
from Virginia
I mainly use these for adult coloring but my daughter uses them for school art projects as well. We both love them. They are very soft and creamy and the colors are so rich and earthy. Best pencils I have used. I read somewhere, on a pencil blog I think, that they are clay based and are softer than prismas.
Love these pencils
By Bille
from Kansas
These pencils are easy to use and blend.
Perfect shopping experience. Top quality. Great price.
By i2collect
from Massachusetts
Great selection of quality colored pencils . A+
Loading item data...
Please allow ADDITIONAL DELIVERY TIME for factory-shipped items.
Click here to view expected shipping dates, or call our Order Dept (800)-828-4548.
Copyright © 2015 Dick Blick Art Materials. All rights reserved.
Your cart is currently empty.
Your cart currently contains N item.
Dick Blick Art Materials®, Blick®, Blick Studio®, and Artists Pick Blick® are registered trademarks of Dick Blick Holdings Inc.
© Copyright 1999-2015 Dick Blick Holdings Inc. All rights reserved.


text:
We took a friend's recommendation to choose this hostel. Before we set off the trip, the host Candy helps us arrange a tour to Halong Bay through email and phone call with an acceptable price and let us keep our package for free. We got a little lost when we tried to walk to the hostel from Hanoi station, I... More
What is Certificate of Excellence?
TripAdvisor gives a Certificate of Excellence to accommodations, attractions and restaurants that consistently earn great reviews from travellers.


text:
- BoliviaRetailFunding via Fundación Pro Mujer
MiriamBoliviaRetailFunding via IMPRO
Cusisis Sar...BoliviaRetailFunding via Fundación Pro Mujer
Sartasiñani Group
Mrs. Antonia has participated in Pro Mujer for three years and joined the institution by invitation from her daughter. Currently she runs a neighborhood store that she began several years ago, having learned the trade from her mother.
The loan she has requested is to increase her working capital to buy canned goods from wholesale dealers at La Ceja. She will then sell them at her store. This will allow her to generate more income to support her family. She is married and has six children.
When asked what she enjoys most about Pro Mujer, she says it is the savings and interest rate.
La señora Antonia, indica que es el tercer año que trabaja en Pro Mujer y que integro la institución por invitación de su hija. En la actualidad ella tiene un negocio de tienda de barrio que viene trabajando hace años, aprendiendo el mismo de su madre.
El crédito que ahora sacará es para aumentar su capital (compra de conservas) que comprara de la Ceja, de las mayoristas y posteriormente a la elaboración lo venderá en su espacio de venta. Esta forma de trabajo le permite generar recursos para apoyar a su familia, pues ella es casada y tiene seis hijos.
Cuando se le consulta qué le gusta de Pro Mujer, ella responde que le gusta los ahorros y los intereses.
Additional Information
This is a Group Loan
In a group loan, each member of the group receives an individual loan but is part of a larger group of individuals. The group is there to provide support to the members and to provide a system of peer pressure, but groups may or may not be formally bound by a group guarantee. In cases where there is a group guarantee, members of the group are responsible for paying back the loans of their fellow group members in the case of delinquency or default.
Kiva's Field Partners typically feature one borrower from a group. The loan description, sector, and other attributes for a group loan profile are determined by the featured borrower's loan. The other members of the group are not required to use their loans for the same purpose.
About Bolivia
109View loans »
Success!! The loan was 100% repaid
- Repayment Term
- 6 months (Additional Information)
- Repayment Schedule
- Monthly
- Pre-Disbursed:
- Dec 1, 2011
- Listed
- Dec 21, 2011
- Currency Exchange Loss:
- Covered
- Ended:
- May 15, 2012


text:
USDA Rural Housing Service:
Reengineering and Reinvention of the Direct Section 502 and 504 Single Family Housing Program
OGC-97-6: Published: Dec 5, 1996. Publicly Released: Dec 5, 1996.
Additional Materials:
View Report (HTML)
- Full Report:
(202) 512-4800
Pursuant to a legislative requirement, GAO reviewed the Rural Housing Service's (RHS) new rule on reengineering and reinvention of the Direct Section 502 and 504 Single Family Housing Program. GAO found that: (1) the rule would set forth revised and combined rules for carrying out the requirements of sections 502 and 504 of the Housing Act of 1949 and combines the current 18 regulations into one rule as part of the National Performance Review Program; (2) the rule, among other changes, implements a Dedicated Loan Origination System which will utilize many of the methods used by private mortgage companies to improve program performance and efficiency to the program's customers; and (3) RHS did not comply with applicable requirements in promulgating the rule, since it improperly accelerated the rule's effective date.
Jan 8, 2016
Troubled Asset Relief Program:Status of Housing ProgramsGAO-16-279R: Published: Jan 8, 2016. Publicly Released: Jan 8, 2016.
Sep 15, 2015
Affordable Rental Housing:Assistance Is Provided by Federal, State, and Local Programs, but There Is Incomplete Information on Collective PerformanceGAO-15-645: Published: Sep 15, 2015. Publicly Released: Sep 15, 2015.
Jul 23, 2015
Low-Income Housing Tax Credit:Joint IRS-HUD Administration Could Help Address Weaknesses in OversightGAO-15-330: Published: Jul 15, 2015. Publicly Released: Jul 23, 2015.
Jul 10, 2015
HUD Public and Indian Housing Programs:Progress on Prior GAO Recommendations to Enhance Accountability and EfficiencyGAO-15-747T: Published: Jul 10, 2015. Publicly Released: Jul 10, 2015.
Jul 6, 2015
Troubled Asset Relief Program:Treasury Could More Consistently Analyze Potential Benefits and Costs of Housing Program ChangesGAO-15-670: Published: Jul 6, 2015. Publicly Released: Jul 6, 2015.
May 19, 2015
Rural Housing Service:Progress on GAO Recommendations and Preliminary Observations on Loan Guarantee Risk ManagementGAO-15-625T: Published: May 19, 2015. Publicly Released: May 19, 2015.
Apr 16, 2015
Persons with HIV:Funding Formula for Housing Assistance Could Be Better Targeted, and Performance Data Could Be ImprovedGAO-15-298: Published: Apr 16, 2015. Publicly Released: Apr 16, 2015.
Apr 9, 2015
- Data Use and Regulatory Status of the Indian Housing Block Grant ProgramGAO-15-353R: Published: Mar 10, 2015. Publicly Released: Apr 9, 2015.
Mar 16, 2015
Military Base Realignments and Closures:Process for Reusing Property for Homeless Assistance Needs ImprovementsGAO-15-274: Published: Mar 16, 2015. Publicly Released: Mar 16, 2015.
Feb 4, 2015
Department of Housing and Urban Development:Violation of Anti-Lobbying Provision and the Antideficiency ActGAO-15-360T: Published: Feb 4, 2015. Publicly Released: Feb 4, 2015.
Looking for more? Browse all our products here


text:
Rail Funds Rejected by Florida Up for Grabs
WASHINGTON—The Obama administration launched a monthlong process Friday to determine which states will receive $2.4 billion to upgrade and construct passenger-rail lines, after Florida rejected the funds last month.
Transportation Secretary Ray LaHood said he would redistribute the money through a competitive process, with an April 4 deadline for states to apply. The move kicks off what is sure to be an intense lobbying campaign among states vying for the money, including California and New York, which have already written to the transportation secretary.
Florida Gov. Rick Scott's rejection of the money—following the footsteps of fellow Republican governors in Ohio and Wisconsin—has raised questions about the Obama administration's vision for a nationwide high-speed rail network. Mr. LaHood has defended the program against Republican claims of government waste, contending that the rail funds will create jobs and spur economic development.
Friday, Mr. LaHood said states have been "banging down our door" for the Florida money.
The administration must now decide whether to award the money to construction of new, high-profile lines, such as a proposed bullet train between Los Angeles and San Francisco, or to smaller projects such as upgrades to Amtrak lines in the Northeastern states.
The Transportation Department said awards would be "merit-driven," going to projects that promise "public and economic benefits quickly."
"A project's ability to reduce energy consumption, improve the efficiency of a region's overall transportation network, and generate sustained economic activity along the corridor are among the selection criteria," the agency said.
Write to Josh Mitchell at firstname.lastname@example.com


text:
STARmeterSEE RANK
Up 25,263 this week
Henry Hampton (1940–1998)
Henry Hampton was born on January 8, 1940 in St. Louis, Missouri, USA as Henry Eugene Hampton. He was a producer and writer, known for American Experience (1988), I'll Make Me a World (1999) and America's War on Poverty (1995). He died on November 22, 1998 in Boston, Massachusetts, USA. See full bio »
Died:(age 58) in Boston, Massachusetts, USA


text:
Legislation such as the Georgia Law of December 19, 1829, represented one threat to the survival of the Cherokee nation. Even as the Georgia legislature acted, Wilson Lumpkin, Georgia's representative on the House Committee an Indian Affairs, worked to secure national legislation further implementing the policy of Indian removal. A bill, reported to the House on February 24, 1830, specified that the president be authorized "to exchange the public domain in the West for Indian lands in the East, to give perpetual title to the country thus exchanged, to pay for improvements made upon the old possessions, and to give aid and assistance in emigration. The measure was not to interfere with existing treaties and the sum of $500,000 was [to be] appropriated for the purpose of making removal possible."1 This bill brought forth protracted and vehement debate in both houses of Congress. The most notable speech made was that of New Jersey's Senator Frelinghuysen, then serving his only term in the Senate. Frelinghuysen spoke for six hours, over a period of three days, and became nationally famous. On the basis of this speech against Indian removal, Frelinghuysen was denominated, in a poem by the abolitionist William Lloyd Garrison , "patriot and Christian." The name stuck. Frelinghuysen, who went on to become president of the American Bible Society, chancellor of New York University, vice-presidential candidate of the Whigs in 1844, and, finally, president of Rutgers College, was known for the rest of his life as the "Christian statesman."
GOD, in his providence, planted these tribes on this western continent, so far as we know, before Great Britain herself had a political existence. I believe, Sir, it is not now seriously denied that the Indians are men, endowed with kindred faculties and powers with ourselves; that they have a place in human sympathy, and are justly entitled to a share in the common bounties of a benignant Providence. And, with this conceded, I ask in what code of the law of nations, or by what process of abstract deduction, their rights have been extinguished?____________________


text: El Nino appears to be gradually developing in the tropical Pacific Ocean. A full-fledged El Niño episode means that Atlantic hurricane activity will probably be suppressed this year. El Nino usually causes strong upper-level winds and high wind shear, both of which contribute to less tropical activity in the Atlantic Ocean and Gulf of Mexico. Depending on how quickly it develops, there could be a rapid shutdown of tropical storm and hurricane activity during the latter part of the Atlantic season in September and October. Activity is more likely in August and early September, which is before the El Nino is expected to develop.


text:
A portfolio of the best color and black-and-white images taken by Thomas Moffatt between 1964 and the present. The inspiration is the larger balance n nature between sky, earth, water, and weather - all in the moments of special light.
Being passionate means learning in depth. In the second decade of the 21st century top passions are continuing to learn the best routes towards family genealogy, including DNA genealogy. But it includes also observing a multi-cat household, and in the past has included long distance explorations on foot through many of the wilder areas of Asia and North America. Tom Moffatt lives in a 208-year-old family home near St. Stephen, New Brunswick and Calais, Maine with his artist wife Anne Johnston and five indoor cats.
Comment posted.
Log in or create an account to post a comment.
Isaac Cook and the House on the Ridge Published October 28, 2009
Katahdin - a Weekend in June Published August 01, 2008
The Cat House - a 30-Year Journey Published August 01, 2008


text:
- PeruAgricultureFunding via Asociación Arariwa
CrisologaPeruAgricultureFunding via Asociación Arariwa
Azucena Bea...PeruClothingFunding via Edpyme Alternativa
Rina Elena
Update on Rina ElenaThe borrower continues in her craft business, selling sweaters, purses and hats. She works from 8:00 a.m. to 7:00 p.m., has been in business several years; and things are going well for her. Her goal is to expand her business. She is requesting a loan to buy hats, purses and sweaters.
The borrower is grateful for the loan and committed to paying it back on time.
La socia se siente agradecida por el préstamo y se compromete a cumplir con los pagos de su cuota.
Previous Loan DetailsRina sells crafts. She has worked in this business many years and it gives her both personal and economic satisfaction. She makes Peruvian sweaters, hats, purses, and other things. By doing this work, she is able to help her family get ahead. She is seeking a loan so that she can buy wool f... More from Rina Elena's previous loan »
Additional Information
Important InformationAbout Asociación Arariwa
Asociación Arariwa is a large non-governmental organization that started offering microcredit in 1994 to improve the quality of life, skills and equity of the population in the rural Cusco region of Peru. Arariwa serves the southern Andean provinces of Peru, and is distinguished by its efforts to reach the very poor, who often live in isolated rural areas. Arariwa fosters village banking, supports savings accounts, promotes access to education, and empowers women entrepreneurs (who make up 78% of its borrowers).
Concurrent and Successive Loans
Our Field Partners often work with borrowers over a series of loans as the borrowers build credit, take out bigger loans, and expand their businesses. In order to make it easier for our Field Partners to post loans for borrowers who have been listed on Kiva before, we allow them to post successive and concurrent loans for their Kiva borrowers. This means that our Field Partners are able to post a borrower's second, third, etc., loan on Kiva without having to re-enter all of the borrower's information.
This borrower has been listed on Kiva before, so you'll see an updated loan description, as well as excerpts of the original descriptions from earlier loans. Most borrowers take out loans consecutively, meaning that they receive a second loan after having repaid the first. However, sometimes our Field Partners give out concurrent loans, allowing borrowers to take out one primary loan and a secondary "add-on" loan along with it. These "add-on" loans are typically smaller than the borrower's primary loan and serve a different purpose. Because Field Partners can now post loans as successive and concurrent loans, you will be able to track borrower progress over time and see the various ways a borrower is working with our Field Partners through funds from Kiva's lenders.
About Peru
48View loans »
Success!! The loan was 100% repaid
- Repayment Term
- 6 months (Additional Information)
- Repayment Schedule
- Monthly
- Pre-Disbursed:
- Aug 13, 2013
- Listed
- Sep 11, 2013
- Currency Exchange Loss:
- Possible
- Ended:
- Jan 17, 2014
Photo from previous loan
Kiva allows our Field Partners to re-use the same photo for individual borrowers that have been posted on Kiva's website once before in a 24 month period, and we allow them to re-use group photos for up to 24 months, provided that 80% of the current group's membership is represented.
Taking, collecting, and uploading photos of borrowers is one of the most challenging elements of using Kiva for our Field Partners. In order to make Kiva easier for Field Partners to use, we have allowed them to post successive and concurrent loans without taking a new photo of the borrower if the criteria above are met.


text:
Child Safety: Child Safe Blinds & Shades
- Ensures the safest room for children
- All products have cord-free options
- WCMA approved cordless options
- Cordless operation is easy at low heights
- Add motorization for hard to reach windows
Blindsgalore supports the Window Covering Safety Council (WCSC) and the Window Covering Manufacturers Association (WCMA) in providing window treatments that meet the highest standards in cord safety to avoid any unwanted injuries or mishaps. The WCMA has created the Certified Best for Kids label to help identify products that are both suitable and strongly recommended in homes with young children. This certification program is the first of its kind and cordless lift options with this label have undergone rigorous third-party testing to ensure they meet stringent safety criteria. Select lift options labeled as Certified Best for Kids for utmost safety. Blindsgalore also recommends upgrading to a motorized blind or shade when available for extra protection and greater accessibility. Window treatment options that have been Certified Best for Kids are the smartest and safest choice for all of your blinds and shades.
Bali® DiamondCell® Cellular Shades: Blackout Midnight and Legacy
retail $100.03 $67.00 + an extra 20% off
Certified Best for Kids
Products with this label meet or exceed safety recommendations approved by the Window Covering Manufactures Association (WCMA) and have undergone rigorous third-party testing.
Blindsgalore® Select Cellular Shades: 3/4" Blackout
retail $135.86 $91.00 + an extra 20% off
Certified Best for Kids
Products with this label meet or exceed safety recommendations approved by the Window Covering Manufactures Association (WCMA) and have undergone rigorous third-party testing.
Double Cell (1)
Multi-cell construction provides excellent insulation
Single Cell (1)
Provides great insulation in a wide variety of pleat sizes
- Double Cell (1)
- Single Cell (1)
- refine
3/8" Pleat (1)
.375 inch (3/8 of an inch), are the thinnest available, and equivalent to 32 pleats per foot.
3/4" Pleat (1)
.75 inch (3/4 of an inch), are the second largest available, and equivalent to 16 pleats per foot.
- 3/8" Pleat (1)
- 3/4" Pleat (1)
- refine
Privacy (1)
Take a look at our wide selection of privacy window treatments.
Remote Control / Motorized (1)
Take a look at our wide selection of motorized blinds and window treatments
Top Down/Bottom Up (1)
Top down bottom up is ultimate privacy and light control option - raise the shade from the bottom, the top, or both
Bali (1)
Since 1939, Bali has been providing beautiful, quality window treatments to customers around the world. Choose from a comprehensive selection of Bali blinds and shades.
Blindsgalore (1)
Save money without sacrificing quality. Choose from Blindsgalore's signature line of custom window treatments and coverings.
- Bali (1)
- Blindsgalore (1)
- refine
Horizontal (1)
Horizontal blinds and shades operate up and down instead of side to side. These types of blinds work well on nearly all windows except sliding doors.
- Horizontal (1)
- refine
Black (1)
Try black window treatments for a striking contrast and modern look
Blue (1)
Choose from our great selection of window treatments featuring materials and fabrics in numerous shades of blue
Gray (1)
Choose from light gray tones to deep slate colors - everything between white and black
Green (1)
Choose from our selection of window treatments featuring green fabrics and materials.
Purple (1)
Choose from our selection of window treatments featuring purple fabrics and materials.
Red / Pink (1)
Choose from our selection of window treatments featuring red or pink fabrics and materials
Bathroom (1)
Choose from our selection of recommended window treatments for your bathroom
Dining Room (1)
Take a look at all of our recommendations for window blinds and shades for your dining room
Home Theater (1)
Take a look at all of our recommendations for window blinds and shades for your home theater
Kids Room (1)
Find safe, durable and cordless blinds and shades for your child's room at Blindsgalore.
RV / Motorhome (1)
Upgrade your RV, motorhome or trailer with the perfect custom window blinds or shades. We've handpicked a selection of window treatments that are best suited to installation in RVs and campers that fit any style and budget.
- Bathroom (1)
- Dining Room (1)
- Home Theater (1)
- Kids Room (1)
- RV / Motorhome (1)
- refine
Hard-to-Reach (1)
Take a look at all of our blinds and shades for hard-to-reach windows
Sidelights (1)
Top picks for tight spaces. Maintain your privacy.
- Hard-to-Reach (1)
- Sidelights (1)
- refine
Energy Efficient (1)
Energy efficient window coverings help lower your utility bill and while making your home more beautiful.
DiamondCell™ (1)
Bali DiamondCell cellular shades offer fashion-forward window coverings at the right price
- DiamondCell™ (1)
- refine
customer reviews for child safety
"great shade"
By from
This cellular shade is of good constuction and quality. It is excellent for blocking light.View this product
"Love Bali cellular shades"
By from Williamsburg
The Bali cellular shades (Midnight style blackout type) look great.View this product


text:
Hire Beach Music in Bowling Green, OH
ELVIS IS IN THE BUILDING! Performed by veteran musician/entertainer Tom Fivenson,…
Elvis Impersonator / Beach Music
Plymouth, MI
Acoustic Band / Beach Music
Livonia, MI
Cover Band / Beach Music
Detroit, MI
Party Band / Beach Music
Royal Oak, MI
Island Jeff/ The Island Jeff Band performs the best Island Music by Jimmy Buffett,…
Caribbean/Island Music / Beach Music
North Royalton, OH
Guitarist / Beach Music
Cleveland, OH
The Explosion of a High Energy Musical Performance Band that will have your guests…
Wedding Band / Beach Music
Cleveland, OH
Dance Band / Beach Music
Cleveland, OH
Steel Drum Music | Fun for all ages | Affordable! Add a cool island sound to your…
Steel Drum Player / Beach Music
Cleveland, OH
Live entertainment with an island attitude Guitarist/Vocalist/Entertainer featuring…
Guitarist / Beach Music
Cleveland, OH
Steel Drum Player / Beach Music
Cleveland, OH
Hello, Let Rock Capital Productions be your one stop shop to book live entertainment…
Rock Band / Beach Music
Akron, OH
is the nations number 1 Jimmy Buffett tribute act. The band has been together for…
Jimmy Buffett Tribute / Beach Music
Dayton, OH
About the Band: "Sean West and The Poets & Pirates: The Kenny Chesney Tribute…
Tribute Band / Beach Music
Dayton, OH
Steel Drum Player / Beach Music
St Louis, MI
Jazz Band / Beach Music
Indianapolis, IN
Tell us about your event:
Complete the form below to receive FREE no-obligation quotes from performers/vendors in your area.
You can't do that.
You are prohibited from contacting any members on GigSalad.
Reason given:
If you believe that this is in error you may contact us.
Thank You!
Here's what to expect next:
Professionals will respond to your request with a quote for your event. We strongly recommend that all communication be kept on the GigSalad website using our booking and messaging system.
Bookings and communications taking place outside of GigSalad are not eligible for dispute resolution, secure deposit payments, verified reviews, or GigSalad booking protection.
For your protection, please be sure to complete your booking through GigSalad.
It looks like you already sent this request to {{duplicateRequests | multipleRequests}}, you can follow up with them through your inbox.
Connect with us on Facebook:
Browse other talent: {{relatedCategories}}


text:
Jim Adams
i Like to try to keep positive outlook in every situation.I like to have fun, hang out, go to a movie, go to nice dinner and just have fun.There no perfect relationship, just two people that are willing to put work into it to make it perfect. ]
Jim Adams hasn't created any events. Follow Jim Adams to be notified when they create a new event.


text:
- ColombiaArtsFunding via Interactuar
Omar HumbertoColombiaConstructionFunding via Interactuar
Jhon SebastianColombiaServicesFunding via Interactuar
John Jairo
Update on John JairoJohn is creative and intelligent. As well as being very active, he feels very close to the planet and to the environment.
John is a craftsman; he collects various recyclable materials in order to create his own art.
John is applying for a loan in order to buy tools for cutting tyres, on of the main items he uses in his work.
This loan will give John the opportunity to dream of a future where he can produce large art projects that will be valued by everybody, through their love for the environment and culture.
El es artesano por vocación y recoge diferentes materiales reciclables para crear obras de arte que salen de su propia inspiración y creatividad.
El solicita un préstamo para comprar herramientas de corte de llantas ya que este es uno de los principales elementos que utiliza en sus obras.
El préstamo le dará la oportunidad de soñar con un futuro donde pueda realizar obras a gran escala y que las personas las valoren por su sentido cultural y ambientalista.
Previous Loan DetailsJohn, 41, is married and has three children, for whom he works hard to support. Since childhood, he has has an affinity for making handicrafts. He collected things that others had thrown away and made them into useful, decorative objects to sell to family and acquaintances. With time, he became r... More from John Jairo's previous loan »
Additional Information
Important InformationThis loan is structured on Kiva as a bullet loan, which means a single payment is required at the end of the loan term. By Colombian law, Kiva's partner Interactuar is required to offer borrowers loans with a variable interest rate that fluctuates with the market rate. Because fixed monthly payments are applied first to interest and then to principal, Interactuar is unable to predict upfront what portion of each repayment would go towards the loan principal. This creates a challenge with Kiva's system, which doesn't allow for unpredictable principal payments, and can result in some Interactuar clients appearing falsely delinquent. To remedy this, the loan has an end-of-term repayment plan on Kiva, but the borrower will continue scheduled monthly repayments to Interactuar, who will then pass along the principal amount to Kiva lenders. This means that you may see repayments made on this loan throughout the repayment term, as opposed to receiving repayment in full at the end of the loan term.
Concurrent and Successive Loans
Our Field Partners often work with borrowers over a series of loans as the borrowers build credit, take out bigger loans, and expand their businesses. In order to make it easier for our Field Partners to post loans for borrowers who have been listed on Kiva before, we allow them to post successive and concurrent loans for their Kiva borrowers. This means that our Field Partners are able to post a borrower's second, third, etc., loan on Kiva without having to re-enter all of the borrower's information.
This borrower has been listed on Kiva before, so you'll see an updated loan description, as well as excerpts of the original descriptions from earlier loans. Most borrowers take out loans consecutively, meaning that they receive a second loan after having repaid the first. However, sometimes our Field Partners give out concurrent loans, allowing borrowers to take out one primary loan and a secondary "add-on" loan along with it. These "add-on" loans are typically smaller than the borrower's primary loan and serve a different purpose. Because Field Partners can now post loans as successive and concurrent loans, you will be able to track borrower progress over time and see the various ways a borrower is working with our Field Partners through funds from Kiva's lenders.
Loan tags help lenders find loans that match certain areas of interest. You can add up to 5 tags for this loan.
About Colombia
374View loans »
Success!! The loan was 100% repaid
- Repayment Term
- 26 months (Additional Information)
- Repayment Schedule
- Monthly
- Pre-Disbursed:
- May 21, 2014
- Listed
- Jun 19, 2014
- Currency Exchange Loss:
- Possible
- Ended:
- Nov 17, 2014


text:
France's Finance and Economy Minister Christine Lagarde leaves the presidential Elysee palace at the end of the weekly cabinet meeting on June 15, 2011 in Paris. Lagarde is being challenged only by Mexico's central bank chief Agustin Carstens, after Israeli central bank governor Stanley Fischer's candidacy was ruled out on June 13 on account of his being too old, to head the International Monetary Fund.
Photo: Getty Images


text:
Identified as a cost-saving and environmentally friendly design choice for parks and other areas with walkways, the Pro-Teq Starpath is a sprayable coating of light-absorbing particles that collects energy during the day and emits light at night. The material is nonreflective, anti-slip and waterproof, according to the manufacturer.
- Applications
- Computing Platforms
- Data
- Gear
- Network
- Security
- Social
- Web
- Budget and Finance
- Health and Human Services
- Justice and Public Safety
- Transportation
- Education


text:
Newegg.com - A great place to buy computers, computer parts, electronics, software, accessories, and DVDs online. With great prices, fast shipping, and top-rated customer service - once you know, you Newegg.
If you are reading this message, Please click this link to reload this page.(Do not use your browser's "Refresh" button). Please email us if you're running the latest version of your browser and you still see this message.
Newegg.com - Computer Parts, Laptops, Electronics, HDTVs, Digital Cameras and More!
Sold and Shipped by Newegg
Filter Results
Great for entry level gamers
This review is from: CyberpowerPC Desktop PC Gamer Ultra 2153 A4-Series APU A4-3400 (2.7 GHz) 8 GB DDR3 1 TB HDD Windows 8 64-Bit
Pros: -It can play Blacklight: Retribution on medium settings and I can also play DayZ with mid-high settings.
Cons: -The l.e.d. was hanging off the fan but I managed to put it back into place.
Other Thoughts: I'm going to buy a graphics card later but for now, games play great with this thing.
Did you find this review helpful?
This item is eligible for Newegg Premier benefits. Are you a Newegg Premier Member? If not, sign up today and get:
We can save it!©
Select a Plan & Save
All storage devices will fail. Data recovery can cost thousands of dollars. Being protected against data loss pays off.
Highest Success Rate
30 years experience. Most technically advanced ISO Class 5 Cleanroom laboratory. All media and storage devices.
Authorized & Recommended
Referred by Western Digital, Apple, Dell, HP, Samsung, Buffalo, Toshiba, Sony, Kingston, OCZ, OWC and many more.
Your request will be processed within the next 24 hours.
Please add "firstname.lastname@example.com" to your address book to ensure delivery.See Today's E-Blast Promo